Page Comparison

...

Currently the SQL is in Snowflake format, but we will be adding support for more databases in the future. 

...

Importing SQL

Coming soon!To export SQL DDL statements from Snowflake, please follow these steps:

1. Log into your Snowflake account.

2. Click on “Create new worksheet” located in the top left corner.

   • If you are unable to create worksheets, please contact your company’s Snowflake administrator for assistance.

...

3. Write the following SQL statement to retrieve the DDL for the desired schema:

SELECT GET_DDL('SCHEMA', '<database>.<schema>');

• For example:

SELECT GET_DDL('SCHEMA', 'ELLIETEST.PUBLIC', TRUE);

...

1. Execute the statement by pressing the play button in the top right menu bar.

...

1. Once the results are displayed, click the download button in the bottom right corner.

• From the menu, select “Download as .csv”. The SQL DDL statements will be saved to your hard drive.

...

To import the SQL into Ellie,

1. Click “Create new model” and select "Physical Model".

2. In the dialog that opens, select “Upload a file”.

3. Choose the file from your hard drive containing the SQL DDL statements.

4. The SQL DDL statements will appear in the dialog.

5. Click “Create new model” to finalize the creation of the new model.

User management

Ellie has two ways to manage users:

...