Mode

Mode Analytics is a platform designed for data analysis, particularly tailored towards data scientists and analysts. The platform provides tools for creating visualizations and reports, and it supports deep data exploration and sharing insights across teams. Using Weld to build a data destination ensures that all your company's systems data is centralized, transformed, and ready for analysis within Mode.

How to connect Mode to Weld

Connect your data in Weld to Mode through a direct connection between your destination and Mode.

Connect Mode to BigQuery

Connecting Mode to Google BigQuery is a straightforward process. Here's how to set it up:

Access Google Developers Console: Log in to the Google Developers Console and select the BigQuery project you want to connect from the drop-down next to Google Cloud. Make sure you are logged into the Google account associated with the project.
Create a Service Account: In the Google Cloud Console, navigate to IAM & Admin > Service Accounts, then click Create service account. Provide a name, unique ID, and description for your service account.
Assign Roles: Assign the necessary roles to your service account, such as BigQuery Job User and BigQuery Data Viewer, to provide it with appropriate access to execute queries and view data.
Generate a JSON Key: Once your service account is set up, go to Manage keys in the Actions menu of the service account. Select ADD KEY > Create new key, choose JSON as the key type, and click CREATE. Download and securely save the JSON key file.
Configure Mode Connection: Log into Mode Analytics and start setting up a new connection to a BigQuery database:
- Name: Enter a descriptive name for the connection to help identify it within Mode.
- Project ID: Enter the BigQuery project ID, which can be found in the URL of your Google Developers Console.
- Service Account Email: Provide the email address associated with the service account.
- JSON Keyfile: Upload the JSON key file that you created in step 4.
Complete the Setup: After filling out all the details, click Connect to test and establish the connection between Mode Analytics and your BigQuery project.

By following these steps, you will be able to successfully connect Mode Analytics to your BigQuery data, enabling you to perform complex analytics and visualizations directly from your datasets.

Connect Mode to Snowflake

Connecting Mode Analytics to Snowflake is a straightforward process. Follow these steps to set up your connection:

Log into Mode Analytics: Open Mode Analytics and log into your account.
Navigate to Database Connections: Go to the Mode home page, click on your name or organization in the bottom left corner, then select Settings. Under the Workspace section, choose Database Connections.
Add a New Database Connection: Click on + New Database and select Snowflake from the list of databases.
Enter Snowflake Credentials: You will need to provide several pieces of information to connect Mode to your Snowflake account:
- Name: Give your connection a name that will help you identify it later.
- Username: Enter the username associated with your Snowflake account.
- Password: Enter the password for your Snowflake account.
Configure Additional Settings: Additional details are required to establish a successful connection:
- Account: Enter your Snowflake account identifier (e.g., xy12345.europe-west4.gcp).
- Role: Specify the Snowflake role that should be used for queries.
- Warehouse: Identify which Snowflake warehouse to use.
- Database: Specify the default database to connect to.
- Schema: Define the default schema to use.
Save Connection: If the test is successful, click Save to finalize the connection.

By following these steps, you will successfully connect Mode Analytics to your Snowflake data destination, enabling you to perform advanced data analytics and create comprehensive reports.