Managing Data Sources

Using data sources, you can share access to data stored in cloud providers, SQL databases, and more with other licensed Dash Enterprise users to use in their apps and App Studio projects.

Adding Data Sources

Prerequisites

• You have the admin role or your Dash Enterprise administrator has assigned you a license seat.

Databricks

To add a Databricks data source:

1. Go to Data Sources.

   <img>
   2. Select Add.

   <img>
   3. Select Databricks.
   4. Enter a Name and optionally a Description and select Continue. Data source names must start with a letter and can contain only alphanumeric characters and underscores.
   5. In Source Credentials, enter the Server Hostname and HTTP Path for the warehouse you want to use. See the Get connection details for a Databricks compute resource page in the Databricks docs for details on accessing this information.
   6. Enter authentication details in the Authentication Method section. You can authenticate with a personal access token or a Client ID and OAuth secret. See the Databricks personal access token authentication page and the Use a service principal to authenticate with Databricks (OAuth M2M) page in the Databricks docs for more details.
   7. Select Test to validate that the authentication you’ve configured is working.
   8. Select Continue.
   9. Configure Access for the data source. Set to Restricted and search for and select users and groups to give them access to the data source, or set to Authenticated to give all licensed users on the platform access to the data source. See the “Access” section later on this page for more details on configuring access.
   10. Select Create.

Snowflake

To add a Snowflake data source:

1. Go to Data Sources.

   <img>
   2. Select Add.

   <img>
   3. Select Snowflake.
   4. Enter a Name and optionally a Description and select Continue. Data source names must start with a letter and can contain only alphanumeric characters and underscores.
   5. Enter a Username, Password, Account, Warehouse. Optionally, you can also provide a specific Database or Schema.

   • Username and Password are the credentials you use to log in to Snowflake, while Account is your organization’s unique account identifier.
   • For details on warehouses, and database and schema information, see the Warehouses and Databases guides and the Database, schema, and share commands reference in the Snowflake docs.

2. Select Test to validate that the authentication you’ve configured is working.

3. Select Continue.
4. Configure Access for the data source. Set to Restricted and search for and select users and groups to give them access to the data source, or set to Authenticated to give all licensed users on the platform access to the data source. See the “Access” section later on this page for more details on configuring access.
5. Select Create.

AWS S3

To add an AWS S3 data source:

1. Go to Data Sources.

   <img>
   2. Select Add.

   <img>
   3. Select AWS S3.
   4. Enter a Name and optionally a Description and select Continue. Data source names must start with a letter and can contain only alphanumeric characters and underscores.
   5. Enter the Bucket Name, Access Key, Secret Access Key, and the AWS Region that the bucket is in.
   - See the Accessing and listing an Amazon S3 bucket page in the AWS docs for details on accessing bucket information.

   • See the Access Keys documentation in the AWS docs for details on generating access keys.
     6. Select Test to validate that the authentication you’ve configured is working.
     7. Select Continue.
     8. Configure Access for the data source. Set to Restricted and search for and select users and groups to give them access to the data source, or set to Authenticated to give all licensed users on the platform access to the data source. See the “Access” section later on this page for more details on configuring access.
     9. Select Create.

AWS Redshift

To add an AWS Redshift data source:

1. Go to Data Sources.

   <img>
   2. Select Add.

   <img>
   3. Select AWS Redshift.
   4. Enter a Name and optionally a Description and select Continue. Data source names must start with a letter and can contain only alphanumeric characters and underscores.
   5. Enter the Host. This is the endpoint for your Redshift cluster.
   6. Enter the Port to use for connecting to Redshift. The default is 5432, but may be different depending on how your cluster is configured.
   7. Enter the Database you want to connect to on the Redshift cluster.
   8. Enter the Username you use to access your Redshift cluster.
   9. Select an authentication method.
   - If using Standard authentication, enter the Password you use to access AWS Redshift.
   - If using AWS Auth, enter the AWS Region, Access Key, and Secret Access Key.
   Note: AWS Auth connections are not currently supported in the schema browser in Dash Enterprise workspaces.
   10. Select Test to validate that the authentication you’ve configured is working.
   11. Select Continue.
   12. Configure Access for the data source. Set to Restricted and search for and select users and groups to give them access to the data source, or set to Authenticated to give all licensed users on the platform access to the data source. See the “Access” section later on this page for more details on configuring access.
   13. Select Create.

Additional resources

• See the AWS Redshift docs on clusters for information on viewing cluster properties, including the Host and AWS Region.
• See Connecting to a database in the AWS Redshift docs for details on viewing available databases on a cluster.
• See the the Access Keys page in the AWS docs for details on generating access keys.

Azure Data Lake

To add an Azure Data Lake data source:

1. Go to Data Sources.

   <img>
   2. Select Add.

   <img>
   3. Select Azure Data Lake.
   4. Enter a Name and optionally a Description and select Continue. Data source names must start with a letter and can contain only alphanumeric characters and underscores.
   5. Enter your the Account Name for your Azure Data Lake storage account and the File System Name within that storage account.
   6. Select if you want to authenticate using Microsoft Entra ID or a SAS Token.
   7. If authenticating with Microsoft Entra ID:
   Provide the Tenant ID, Client ID, and Client Secret.
   If authenticating with an SAS Token enter it in the SAS Token field. If the SAS token only has read permissions, specify the File Name that the token grants access to.
   8. Select Test to validate that the authentication you’ve configured is working.
   9. Select Continue.
   10. Configure Access for the data source. Set to Restricted and search for and select users and groups to give them access to the data source, or set to Authenticated to give all licensed users on the platform access to the data source. See the “Access” section later on this page for more details on configuring access.
   11. Select Create.

Google BigQuery

To add a Google BigQuery data source:

1. Go to Data Sources.

   <img>
   2. Select Add.

   <img>
   3. Select Google BigQuery.
   4. Enter a Name and optionally a Description and select Continue. Data source names must start with a letter and can contain only alphanumeric characters and underscores.
   5. Enter the key information for a Google account that you’ll use to access BigQuery. The required information is available when creating a key for the Google account and can be downloaded as a JSON file. See Create a service account key for details.
   6. Select Test to validate that the authentication you’ve configured is working.
   7. Select Continue.
   8. Configure Access for the data source. Set to Restricted and search for and select users and groups to give them access to the data source, or set to Authenticated to give all licensed users on the platform access to the data source. See the next section, “Access”, for more details on configuring access.
   9. Select Create.

SQL Database

The SQL Database data source type allows you to add SQL databases by specifying a Host, Port, Database, Username, and Password.

To add a SQL database:

1. Go to Data Sources.

   <img>
   2. Select Add.

   <img>
   3. Select SQL Database.
   4. Enter a Name and optionally a Description and select Continue. Data source names must start with a letter and can contain only alphanumeric characters and underscores.
   5. Enter your SQL database’s Host, Port, Database, Username, and Password.
   6. Select Continue.
   7. Configure Access for the data source. Set to Restricted and search for and select users and groups to give them access to the data source, or set to Authenticated to give all licensed users on the platform access to the data source. See the “Access” section later on this page for more details on configuring access.
   8. Select Create.

• See the