> For the complete documentation index, see [llms.txt](https://docs.gapvelocity.ai/blackdiamond-studio-or-mobilize.net/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.gapvelocity.ai/blackdiamond-studio-or-mobilize.net/blackdiamond-studio-documentation/bds-portal/creating-my-first-project/5.-code/2.-extract-ddl-from-snowflake-account.md).

# 2. Extract DDL from Snowflake Account

{% hint style="info" %}
*A connection to a Snowflake account is required to extract code.*
{% endhint %}

If you have your Database connection already set up, this project type allows you to extract your code from the data warehouse. After extracting the code, you can edit it in the BlackDiamond Studio IDE.

1. To start your DDL extraction you only need to click on the **Extract DDL** button.

![](/files/uhdFyt5S0Jhf7fDUx5Oj)

Please be aware that if you don't have your Snowflake account connected, you won't be able to click on the **Extract DDL button.** In the example below, the Extract DDL button is available because the Snowflake connection was completed successfully. 

<figure><img src="/files/dXewVwWP7UzViKDATlIJ" alt=""><figcaption></figcaption></figure>

2\. Then, your source code will be extracted.

![](/files/Zwzx4XLkK9P3UTEHtktX)

3\. Once the extraction is completed, you will be allowed to finish your project setup and navigate to the IDE to start enjoying the BlackDiamond Studio coding experience.

![](/files/nMEUVTE3kHHD6tRb3eB1)