DaLMatian IDE
Installation
Download DaLMatian installer for Mac or Windows. For Mac, must be running macOS Sonoma
Open installer and complete steps
Open DaLMatian (located in Applications or Program Files folder)
Configuration
In Finder, create a new folder
Copy .sql file(s) with past queries you've written (e.g. unorganized scratch files) into the folder
In DaLMatian, File → Open Folder → select your folder
Click on Database icon (4th icon on left panel) and add your schema by either:
Entering your database credentials, or
If you don't have security clearance, manually uploading a csv/xlsx file with the output of this query for your database (export from your usual IDE):
BigQuery
SELECT table_schema AS TABLE_SCHEMA,
table_name AS TABLE_NAME,
column_name AS COLUMN_NAME
FROM `{project_id}.{dataset_name}.INFORMATION_SCHEMA.COLUMNS`
WHERE LOWER(table_schema) NOT IN ('information_schema')
If you connected a database in step 4, in Workspace tab (right panel), click “Resync Workspace”. If you manually uploaded schema, no need to do this step
User Guide
Workspace
This refers to all context (queries, schemas, and instructions) used to answer a question
Suggested set up is one workspace per customer, product, project, etc (some logical grouping like this, depends on your use case)
Context Management
Manage Context - Queries: queries with an associated question/description
Manage Context - Instructions: any overarching rules DaLM should follow
Q&A
Enter a question
DaLM will retrieve relevant queries, explain its reasoning, and generate a query that answers the question
If the generated query is incorrect, you can edit the query directly in code block
Hover over query code block and click Submit to save the query, which will then be displayed with the associated question in Manage Context - Queries
Continue the conversation if there are follow up questions, or click New Chat to start a new conversation
Security
Application is on-prem/local. We (DaLMatian) do not see anything you input. We only track OpenAI API usage
Even if you choose to connect your database, no actual data is accessed, only schema
Equivalent to entering queries on ChatGPT and asking questions with Data Controls "Improve the model for everyone" set to off. OpenAI does not train on anything sent via API (see OpenAI policy here)
DaLMatian IDE
Installation
Download DaLMatian installer for Mac or Windows. For Mac, must be running macOS Sonoma
Open installer and complete steps
Open DaLMatian (located in Applications or Program Files folder)
Configuration
In Finder, create a new folder
Copy .sql file(s) with past queries you've written (e.g. unorganized scratch files) into the folder
In DaLMatian, File → Open Folder → select your folder
Click on Database icon (4th icon on left panel) and add your schema by either:
Entering your database credentials, or
If you don't have security clearance, manually uploading a csv/xlsx file with the output of this query for your database (export from your usual IDE):
BigQuery
SELECT table_schema AS TABLE_SCHEMA,
table_name AS TABLE_NAME,
column_name AS COLUMN_NAME
FROM `{project_id}.{dataset_name}.INFORMATION_SCHEMA.COLUMNS`
WHERE LOWER(table_schema) NOT IN ('information_schema')
If you connected a database in step 4, in Workspace tab (right panel), click “Resync Workspace”. If you manually uploaded schema, no need to do this step
User Guide
Workspace
This refers to all context (queries, schemas, and instructions) used to answer a question
Suggested set up is one workspace per customer, product, project, etc (some logical grouping like this, depends on your use case)
Context Management
Manage Context - Queries: queries with an associated question/description
Manage Context - Instructions: any overarching rules DaLM should follow
Q&A
Enter a question
DaLM will retrieve relevant queries, explain its reasoning, and generate a query that answers the question
If the generated query is incorrect, you can edit the query directly in code block
Hover over query code block and click Submit to save the query, which will then be displayed with the associated question in Manage Context - Queries
Continue the conversation if there are follow up questions, or click New Chat to start a new conversation
Security
Application is on-prem/local. We (DaLMatian) do not see anything you input. We only track OpenAI API usage
Even if you choose to connect your database, no actual data is accessed, only schema
Equivalent to entering queries on ChatGPT and asking questions with Data Controls "Improve the model for everyone" set to off. OpenAI does not train on anything sent via API (see OpenAI policy here)
DaLMatian IDE
Installation
Download DaLMatian installer for Mac or Windows. For Mac, must be running macOS Sonoma
Open installer and complete steps
Open DaLMatian (located in Applications or Program Files folder)
Configuration
In Finder, create a new folder
Copy .sql file(s) with past queries you've written (e.g. unorganized scratch files) into the folder
In DaLMatian, File → Open Folder → select your folder
Click on Database icon (4th icon on left panel) and add your schema by either:
Entering your database credentials, or
If you don't have security clearance, manually uploading a csv/xlsx file with the output of this query for your database (export from your usual IDE):
BigQuery
SELECT table_schema AS TABLE_SCHEMA,
table_name AS TABLE_NAME,
column_name AS COLUMN_NAME
FROM `{project_id}.{dataset_name}.INFORMATION_SCHEMA.COLUMNS`
WHERE LOWER(table_schema) NOT IN ('information_schema')
If you connected a database in step 4, in Workspace tab (right panel), click “Resync Workspace”. If you manually uploaded schema, no need to do this step
User Guide
Workspace
This refers to all context (queries, schemas, and instructions) used to answer a question
Suggested set up is one workspace per customer, product, project, etc (some logical grouping like this, depends on your use case)
Context Management
Manage Context - Queries: queries with an associated question/description
Manage Context - Instructions: any overarching rules DaLM should follow
Q&A
Enter a question
DaLM will retrieve relevant queries, explain its reasoning, and generate a query that answers the question
If the generated query is incorrect, you can edit the query directly in code block
Hover over query code block and click Submit to save the query, which will then be displayed with the associated question in Manage Context - Queries
Continue the conversation if there are follow up questions, or click New Chat to start a new conversation
Security
Application is on-prem/local. We (DaLMatian) do not see anything you input. We only track OpenAI API usage
Even if you choose to connect your database, no actual data is accessed, only schema
Equivalent to entering queries on ChatGPT and asking questions with Data Controls "Improve the model for everyone" set to off. OpenAI does not train on anything sent via API (see OpenAI policy here)
DaLMatian IDE
Installation
Download DaLMatian installer for Mac or Windows. For Mac, must be running macOS Sonoma
Open installer and complete steps
Open DaLMatian (located in Applications or Program Files folder)
Configuration
In Finder, create a new folder
Copy .sql file(s) with past queries you've written (e.g. unorganized scratch files) into the folder
In DaLMatian, File → Open Folder → select your folder
Click on Database icon (4th icon on left panel) and add your schema by either:
Entering your database credentials, or
If you don't have security clearance, manually uploading a csv/xlsx file with the output of this query for your database (export from your usual IDE):
BigQuery
SELECT table_schema AS TABLE_SCHEMA,
table_name AS TABLE_NAME,
column_name AS COLUMN_NAME
FROM `{project_id}.{dataset_name}.INFORMATION_SCHEMA.COLUMNS`
WHERE LOWER(table_schema) NOT IN ('information_schema')
If you connected a database in step 4, in Workspace tab (right panel), click “Resync Workspace”. If you manually uploaded schema, no need to do this step
User Guide
Workspace
This refers to all context (queries, schemas, and instructions) used to answer a question
Suggested set up is one workspace per customer, product, project, etc (some logical grouping like this, depends on your use case)
Context Management
Manage Context - Queries: queries with an associated question/description
Manage Context - Instructions: any overarching rules DaLM should follow
Q&A
Enter a question
DaLM will retrieve relevant queries, explain its reasoning, and generate a query that answers the question
If the generated query is incorrect, you can edit the query directly in code block
Hover over query code block and click Submit to save the query, which will then be displayed with the associated question in Manage Context - Queries
Continue the conversation if there are follow up questions, or click New Chat to start a new conversation
Security
Application is on-prem/local. We (DaLMatian) do not see anything you input. We only track OpenAI API usage
Even if you choose to connect your database, no actual data is accessed, only schema
Equivalent to entering queries on ChatGPT and asking questions with Data Controls "Improve the model for everyone" set to off. OpenAI does not train on anything sent via API (see OpenAI policy here)