dbt research project proposal sample

Below given are the sample forms of eProMIS. Click to download them. R&D Projects

Societal projects, sc/st projects, multi component, other category, proposal evaluation format for peer review, declaration certificate.

Documents / Information to be kept ready before completing the online DBT-RA application

• Active Email ID.
• Self-attested pdf copy of DOB certificate (eg, X Marks card).
• Active mobile number.
• Self-attested pdf copies of degree certificates.
• If PhD/MD/MS (Medical) degree certificate is not available, a pdf copy of provisional award certificate/proof of thesis submission certificate from Registrar/Controller of Examinations is required. Certificate issued from any other authority in this regard is not acceptable.
• PhD Supervisor's Email ID.
• PhD Supervisor's Mobile number.
• Brief Synopsis of PhD/MD/MS Thesis (250 words maximum).
• List of Research Publications with Impact Factor (ISI only). DOI of a Publication should be entered correctly, without using any extra character. For example, the correct way of entering the DOI of a publication is 10.1101/sqb.1900.018.01.020 and NOT 10.1101/sqb.1900.018.01.020. or https://doi.org/10.1101/sqb.1900.018.01.020. If DOI is not available, enter '0'. The applicant should enter his/her name in CAPITAL letters in the Authors' list of a publication, and the names of co-authors should be in SMALL letters.
• List of Patents, if available.
• Title of the Proposed Research work.
• Summary of the Proposed research work with background, rationale of the study, hypothesis, and objectives (500 words maximum).
• Proposed Mentor’s Designation.
• Proposed Mentor’s Email ID.
• Proposed Mentor’s Mobile number.
• Name and date of joining of DBT-RA currently working with your proposed Mentor, if any.
• PDF copy of Consent Letter from the proposed Mentor in this format.
• Enter name, address, mobile number, and email ID of two referees in the online application, send links to them by Clicking the “Submit” button. Your referees could be your thesis supervisor and other Professor/Employer with whom you’ve had a close working relationship. It is responsibility of the candidates to make sure that the referees have uploaded and submitted pdf copies of the recommendation letters online, using the links emailed to them by the candidates. The DBT-RA office is unable to accept recommendation letters via email or post.
• No hard copy of the application is required.
• Candidates in the NE-stream are those whose permanent residences are located in the NER, and they can work anywhere in the country.
• Candidates in the N-stream are those whose permanent residences are located in rest of the country, and they can work anywhere in the country.

Navigation Menu

Search code, repositories, users, issues, pull requests..., provide feedback.

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly.

To see all available qualifiers, see our documentation .

• Notifications You must be signed in to change notification settings

A sample project to attempt to highlight most of the features of dbt in one fairly simple repo. It uses common dbt samples projects and adds in some additional useful features.

TheDataFoundryAU/dbt_sample_project

Folders and files.

Repository files navigation

The data foundry - sample dbt project.

This project is based on the standard jaffle shop model for dbt, including additional other models to replicate a more real world situation.

The purpose of this project is to show how to structure DBT projects as there are a number of ways, and they can conflict with each other if specific parts are not made explicit.

Table of Contents

Materialisation, documentation macros, key areas included.

The standard location for a profile file is ~/.dbt/profiles.yml but if you are running multiple projects (eg. different clients) you might find it easier to keep multiple profile.yml files

The default dbt run command will look in the standard location, so if using multiple profiles use the following command

You can run multiple projects on a dbt profile, or you can build them all into one. If you have multiple projects you will have a copy of this folder structure for each project. DBT looks for a file called dbt_project.yml to define the details of the project.

dbt Doco - Tags

Tags can be used to separate out parts of a model so that it can be run in parts. This might be for dev purposes, different parts needing different run schedules (eg daily and hourly sections) or any other reason you need.

Tags need to be defined in 3 places, the project level, the model level (folder) or within the individual model. This project has some example tags within the base dbt_project.yml configured.

To run dbt for a tagged subset use the following code (assuming using a local profile)

dbt Doco - Tests

Tests are important. Write tests.

Tests can be run against columns or tables. DBT contains only 4 built in tests, but can be expanded as needed with custom tests.

Tests can be run using the dbt test command.

All of the models have tests in them, but custom tests (using dbt_utils) are being used in the mrr model. A custom model of date_format_check is set to run on jaffles.order.order_date. Note that this test may return a SQL error, as the order field is already a date column and there seems to be a bug in Snowflake where running this function on a date breaks things.

Targets (maybe better thought of as stages) allow for you to use your dbt project in different configurations as defined in your profiles.yml file. The sample profile has two targets to show how this might be used.

Targets will use what is defined in the target: key in the profile and can be overridden as needed to run in a different target. Probably the most common use case is leaving as dev , then setting a target or test or prod at runtime as needed. To use a specific target at runtime use the command below

DBT can include additional packages to serve a number of functions. For more info look here and here

dbt-codegen is included in packages as an example, but packages can also be from a git repo too.

To install the dependancies run the following command:

Example usage:

DBT can automatically generate documentation of the environment. This contains a bunch of useful info like the columns, tests being run, the SQL and so on.

dbt also generates lineage graphs as part of the docs. This can be really helpful in debugging when you have a lot of models and dependancies.

To generate the docs run the command below:

To view the docs use this:

Data quality, data standards, consistency, who wants to do all that?! You should!

Thankfully dbt makes that much easier when using this. In the models/jaffles/schema.yml file on the status column you'll see how its used. This, populates into the docs above and makes for some nice easy docs that are referenced in a single place. Notice in the customer_id column you can even include images in the doco if there is value.

Jaffle Shop

Testing dbt project: jaffle_shop.

jaffle_shop is a fictional ecommerce store. This dbt project transforms raw data from an app database into a customers and orders model ready for analytics.

What is this repo?

What this repo is :

• A self-contained playground dbt project, useful for testing out scripts, and communicating some of the core dbt concepts.

What this repo is not :

• A tutorial — check out the Getting Started Tutorial for that. Notably, this repo contains some anti-patterns to make it self-contained, namely the use of seeds instead of sources.
• our standard file naming patterns (which make more sense on larger projects, rather than this five-model project)
• a pull request flow
• CI/CD integrations
• A demonstration of using dbt for a high-complex project, or a demo of advanced features (e.g. macros, packages, hooks, operations) — we're just trying to keep things simple here!

What's in this repo?

This repo contains seeds that includes some (fake) raw data from a fictional app.

The raw data consists of customers, orders, and payments, with the following entity-relationship diagram:

Running this project

To get up and running with this project:

Install dbt using these instructions .

Clone this repository.

Change into the jaffle_shop directory from the command line:

Set up a profile called jaffle_shop to connect to a data warehouse by following these instructions . If you have access to a data warehouse, you can use those credentials – we recommend setting your target schema to be a new schema (dbt will create the schema for you, as long as you have the right privileges). If you don't have access to an existing data warehouse, you can also setup a local postgres database and connect to it in your profile.

Ensure your profile is setup correctly from the command line:

• Load the CSVs with the demo data set. This materializes the CSVs as tables in your target schema. Note that a typical dbt project does not require this step since dbt assumes your raw data is already in your warehouse.
• Run the models:

NOTE: If this steps fails, it might mean that you need to make small changes to the SQL in the models folder to adjust for the flavor of SQL of your target database. Definitely consider this if you are using a community-contributed adapter.

• Test the output of the models:
• Generate documentation for the project:
• View the documentation for the project:

What is a jaffle?

A jaffle is a toasted sandwich with crimped, sealed edges. Invented in Bondi in 1949, the humble jaffle is an Australian classic. The sealed edges allow jaffle-eaters to enjoy liquid fillings inside the sandwich, which reach temperatures close to the core of the earth during cooking. Often consumed at home after a night out, the most classic filling is tinned spaghetti, while my personal favourite is leftover beef stew with melted cheese.

For more information on dbt:

• Read the introduction to dbt .
• Read the dbt viewpoint .
• Join the dbt community .
• Shell 100.0%

Opportunities

Twas-ncp postdoctoral fellowship programme, twas-sn bose postdoctoral fellowship programme, twas-sn bose postgraduate fellowship programme, twas fellowships for research and advanced training, twas visiting expert programme, twas-dbt postdoctoral fellowship programme, department of biotechnology (dbt), india.

The Department of Biotechnology (DBT) is an Indian government department, under the Ministry of Science and Technology, responsible for administering development and commercialization in the field of modern biology and biotechnology at a number of centres of excellence in India, including university departments and CSIR institutes and laboratories. TWAS and DBT collaborate in the framework of the TWAS-DBT Postgraduate Fellowship Programme and the TWAS-DBT Postdoctoral Fellowship Programme .

Applications can only be submitted via online portal once the call is open.

Please use the “apply now” button at the bottom of this page to start your application once the call is open.

Opening date of this fellowship: 15 December 2023

Closing date of this fellowship: 19 March 2024

Applicants are encouraged to apply for the preliminary acceptance letter as early as possible, even before the opening date of the call. Keeping in mind that only Acceptance letters dated the same year as the year of application are eligible.

Programme Details

• TWAS-DBT Postdoctoral Fellowships are tenable at key biotechnology research institutions in India for a minimum period of 12 months to a maximum period of 18 months.
• Note regarding eligible fields: if choosing Biological Sciences or Chemical Sciences only Biotech Aspects are eligible.
• To help candidates in their choice of a suitable host institution a list of biotechnology institutes in India is available is available below (under Application Documents).  However, candidates are free to choose an Indian biotechnology institution that does not appear on the list.
• DBT will provide a monthly stipend of Rs. 61,000/- + HRA and health insurance of Rs. 600/- per month. The fellowship holder will receive a contingency amount of Rs. 50,000/- per annum and shall be eligible to receive House Rent Allowance as per Government of India HRA rules. The fellowship will not be convertible into foreign currency.
• TWAS will provide a lump sum to cover partial travel and initial visa costs.
• The language of instruction is English.

Eligibility

Applicants for these fellowships must meet the following criteria:

• be a maximum age of 45 years within the year of application (31 December)
• be nationals of a developing country (other than India).
• must not hold any visa for temporary or permanent residency in India or any developed country.
• hold a PhD degree in bioscience or biotechnology.
• be regularly employed in a developing country and hold a research assignment there.
• be accepted at a biotechnology institution in India (see sample Acceptance Letter that can be downloaded below or included in the application form). N.B. Requests for acceptance must be directed to the chosen host institution(s), and NOT to DBT.
• provide a research proposal outline based on the format of the sample that can be downloaded below.
• provide evidence of proficiency in English, if medium of education was not English;
• provide evidence that s/he will return to her/his home country on completion of the fellowship;
• not take up other assignments during the period of her/his fellowship;
• be financially responsible for any accompanying family members.

Submitting your application

• The opening date of the call is 15 December 2023.
• The deadline for receipt of applications is 19 March 2024.
• Applicants should submit the Acceptance Letter from an Indian biotechnology institution to TWAS when applying or by the deadline at the latest. Applicants will have until the deadline to submit the Acceptance Letter to TWAS. Without preliminary acceptance, the application will not be considered for selection.
• Should you have applied to or availed any Indian fellowships (especially INSA JRD TATA and JNCASR-CICS) in the current or previous year this must be clearly specified in the application form.
• Applications for the TWAS-DBT Postdoctoral Fellowship Programme can ONLY be submitted to TWAS via the online portal. A tutorial on how to use the online application form is available below for download.
• Applicants should be aware that they can apply for only one fellowship per year. With the exception of the Visiting Scientists programme, all other fellowship programmes offered by TWAS and OWSD are mutually exclusive.

Results of the fellowship selection should be available toward mid or the end of 2024, and selected candidates will be able to start their fellowship NO earlier than beginning of 2025.

Award details:

A total of 10 awards will be considered in the DBT-TWAS Postdoctoral Fellowship programme.

Contact details

• TWAS Fellowships Office

ICTP Campus, Strada Costiera 11

34151 Trieste, Italy

Phone: +39 040 2240-314

Fax: +39 040 224559

E-mail: [email protected]

• DBT Contact

Dr. Manoj Kumar

Scientist ‘D’

Department of Biotechnology

Block 2, CGO Complex

Lodhi Road, New Delhi 110 023

Email: [email protected]

• DBT HRD Project Management Unit Contact

Project Manager DBT HRD Project Management

Regional Centre for Biotechnology (RCB)

Faridabad, Haryana – 121001

Phone: +91-129 2848-800

E-mail:  [email protected]

Are there any example dbt projects?

• Quickstart Tutorial: You can build your own example dbt project in the quickstart guide
• Jaffle Shop: A demonstration project (closely related to the tutorial) for a fictional e-commerce store ( main source code and source code using duckdb )
• GitLab: Gitlab's internal dbt project is open source and is a great example of how to use dbt at scale ( source code )
• dummy-dbt: A containerized dbt project that populates the Sakila database in Postgres and populates dbt seeds, models, snapshots, and tests. The project can be used for testing and experimentation purposes ( source code )
• Google Analytics 4: A demonstration project that transforms the Google Analytics 4 BigQuery exports to various models ( source code , docs )
• Make Open Data: A production-grade ELT with tests, documentation, and CI/CD (GHA) about French open data (housing, demography, geography, etc). It can be used to learn with voluminous and ambiguous data. Contributions are welcome ( source code , docs )

If you have an example project to add to this list, suggest an edit by clicking Edit this page below.

• Biotechnology Industry Research Assistance Council

• Proposal Format

• Code of Conduct
• Publications
• BIRAC Departments

• BioAngels Program
• Fund of Funds - AcE
• Quest for Assistive Technologies
• Banana Fortification
• Establishing preclinical models for Drug discovery
• DBT BIRAC AMR Mission
• ABOUT BIRAC PARTNERSHIPS
• CEFIPRA-BPI France
• DBT-BMGF-BIRAC
• Early Translation Accelator (ETA)
• Grand Challenges India (GCI)
• Industry Innovation Programme on Medical Electronics (IIPME)
• LEHS (WISH)
• National Biopharma Mission
• RAPID USAID-TB Diagnostics Programme
• UKTI (UK Trade & Investment)
• Wellcome Trust
• TATA Trust-Social Alpha
• CSR:Join Hands with BIRAC
• IP & Technology Management Cell
• Call for Proposal

• Call For Proposal

Special Call for Proposals on Priority Agriculture and Secondary Agriculture Areas-24th Batch

Introduction, key features of the call.

Proposals may comprise one or more special elements in the area of focus as given below but not limited to:

1.      Agriculture Priority I: Evolvable Technologies which are a pre-requisite to product delivery

a.       Strengthening of pre-breeding programmes

b.      Use of molecular markers and  accelerated breeding in crops through marker assisted selection to tag genes of interest possibly single major genes  which significantly contribute towards  overcoming a stress response

c.       Use of RNAi-based gene silencing and cytoplasmic male sterility techniques with a view to raising transgenic crops.

2.   Agriculture Priority II:

a.       Heterosis breeding

b.      Incorporation of marker free resistance against biotic (preferably insect, pest and disease) and abiotic (preferably drought ,salinity, heat and submergence) in crop plants.

c.       Raising nutritionally important crops and their Bio fortification.

d.      Development of appropriate diagnostic and detection kits

Priority crops/target traits.

• Orphan crops like millets, legumes and tuber crops cultivated in dry farming and fragile environment. 
• Rice, wheat, maize, sorghum, pulses, oilseeds, and other Horticulture and vegetable crops etc.
• Biotic Stress (preferably insect, pest and disease) and Abiotic Stress (preferably drought, salinity, heat and submergence)
• Yield increase, enhanced quality and shelf life, engineering male sterility and development of apomixes.

Secondary Agriculture

1.      Alternative very high yield crops (more than 100 tons dry/hectare) and technologies for innovative and new renewable fuels, chemicals, enzymes etc.

2.      Environmental management of  bio-processing wastes

3.      Nano science and nano technology  in Bio-processing sector

4.      Biological processing (separation and conversion) of biomass into value added food (animal feed, sweeteners, bakery and confectionary, canned foods, flavour) and non-food (detergents, adhesives, polymers, speciality chemicals, textiles) products

a.  Products from agricultural residue under the following categories:

      i.      Food crops such as Wheat/rice/maize/millet/sorghum cotton/soya/horticulture based

     ii.      Biomass from plantation crops (sugarcane, cocoa and bean waste, coconut, rubber, spices and condiments)

     iii.      Products from distribution and processing waste such as fruits and vegetables (Leafy vegetables, apple pommace, mango, pomegranate, Citrus peels)

     iv.      By-products from edible and non-edible oils and their processing.

      b.      Valuable compounds from marine products harvesting and processing

5.      Valorisation (separation and conversion) of agricultural and agro-industrial waste or by-products into biodegradable packaging, higher value secondary products (such as dietary fiber, phenolic acids), intermediates, food colours/dyes or nutraceutical products

6.      Production (separation and conversion) of value added products from animal products processing and by products including dairy products, meat, poultry and fish products

7.      Value addition to medicinal and aromatic plants through processing and new product development

WHO CAN APPLY?

HOW TO APPLY?

Dr. Suraksha S. Diwan, Program Officer – BIPP,

Scientist C, Department of Biotechnology

ANNOUNCEMENT DATE | LAST SUBMISSION DATE

Announcement Date: 15-08-2012 Last Submission Date: 15-09-2012 12:00 AM

Annual Reports

Dbt-birac mou, tenders  , vacancy , loan non-repayment, supported projects  .

Website Policy

This is the official Website of Biotechnology Industry Research Assistance Council (BIRAC) , a Public Sector Enterprise, set up by Department of Biotechnology (DBT), Government of India © 2024

Last Updated: 22 August, 2024

• GOVERNMENT OF INDIA
• MINISTRY OF SCIENCE & TECHNOLOGY

Search form

Call for Proposals for Biotechnology Based Programme for Societal Development in Rural Areas and Aspirational Districts

Last date for submission of proposals: 14th february 2024 (for north east region and remote/rural areas:25th february 2024).

• Public Grievance
• Website Policies
• Terms & Conditions
• Web Information Manager

• Visitor: 6,031,852