Import and Export Data

If you are working with data stored in a database or hosted somewhere on the cloud, it's often simpler and more efficient to load your data directly into Graphext. By connecting a database or remotely hosted dataset with Graphext, you create a link between your workspace and the source of your data. You only have to integrate a data source with your Graphext workspace once.

Then each time you want to update your project with the latest data, you would refresh the project. This action will retrieve your data in its most up to date form, meaning that you can start analyzing recent data straight away.

Supported data sources

Google BigQuery

How to connect Google Big Query?

  1. Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on.
  2. Select “Big Query” from the integrations list.
  3. Click on “Continue with Google.
  4. Select your Google account and ”Allow” from the Google sign-in permissions window.
  5. Head to the Big Query webpage and copy your Project ID by clicking on the dropdown to the right of the Google Cloud logo. Paste it in the field labeled “Project ID.
  6. Create your SQL query using the Big Query editor or your favorite editor, and paste it in the field labeled “Query.
  7. If you would like other members to edit the query only. Select “Allow team members to edit the above query.”
  8. If you want Graphext to write back the project's output to Big Query. Select “Allow write output.” View more documentation about this step here.
  9. Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.

Snowflake

How to connect Snowflake?

  1. Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on.
  2. Select “Snowflake” from the integrations list.
  3. Introduce your account “Username” and “Password.”
  4. Head to the Snowflake webpage, open the Admin page and click on Accounts.
  5. Hover directly to the right of the Account label, and click the icon to copy the URL. Paste it in the field labeled “Account ID / URL.
  6. Create your query using the Snowflake Worksheets or your favorite editor, and paste it in the field labeled “Query.
  7. If you would like other members to edit the query only. Select “Allow team members to edit the above query.”
  8. If you want Graphext to write back the project's output to Snowflake. Select “Allow write output.”
  9. Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.

Amazon Redshift

How to connect Amazon Redshift?

(Make sure that your cluster is available for connection and that you have configure the IP correctly, in case you need help, we explain you how to do it in the section below "Configure the availability of your cluster and the IP")

  1. Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on.
  2. Select “Amazon Redshift” from the integrations list.
  3. Add your account “Username” and “Password.”
  4. Head to the AWS webpage and select the cluster you want to use.
  5. From the database configurations, copy the “Database” name, the “Port”, and the “Host” and paste them into the corresponding fields.
  6. Create your query using the AWS console or your favorite editor, and paste it in the field labeled “Query.
  7. If you would like other members to edit the query only. Select “Allow team members to edit the above query.”
  8. If you want Graphext to write back the project's output to Amazon Redshift. Select “Allow write output.”
  9. Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.

Configure the availability of your cluster and the IP

Head to Amazon Redshift and make your cluster publicly available.

Ensure you configure the Inbound rules with the correct IP and Port.


PostgreSQL

How to Connect a PostgreSQL Database?

  1. Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on.
  2. Select “PostgreSQL” from the integrations list.
  3. Complete the form by entering your "Username", "Password", "Host", "Port" and "Database key".
  4. Create your query using your favorite editor, and paste it in the field labeled “Query.
  5. If you would like other members to edit the query only. Select “Allow team members to edit the above query.”
  6. If you want Graphext to write back the project's output to PostgreSQL. Select “Allow write output.” View more documentation about this step here.
  7. Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.

Databricks

How to connect Databricks?

  1. Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on.
  2. Head to the Databricks webpage, go to SQL Warehouses, select the one you want to work with, and click on the connection details section.
  3. Copy the Server hostname, and paste it into the field labeled “Host.
  4. Copy the HTTP path, and paste it into the corresponding field.
  5. Head to your Databricks User Settings, select the Access Tokens tab,and copy your token or generate a new one. Paste it into the appropriate field.
  6. Create your query using the Databricks SQL editor or your favorite editor, and paste it in the field labeled “Query.
  7. If you would like other members to edit the query only. Select “Allow team members to edit the above query.”
  8. If you want Graphext to write back the project's output to Databricks. Select “Allow write output.”
  9. Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.

MySQL

How to Connect a MySQL Database?

  1. Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on.
  2. Select “MySQL” from the integrations list.
  3. Complete the form by entering your "Username", "Password", "Host", "Port" and "Database key".
  4. Create your query using your favorite editor, and paste it in the field labeled “Query.
  5. If you would like other members to edit the query only. Select “Allow team members to edit the above query.”
  6. If you want Graphext to write back the project's output to MySQL. Select “Allow write output.” View more documentation about this step here.
  7. Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.

SQL Server

How to Connect an SQL Server?

  1. Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on.
  2. Select “SQL Server” from the integrations list.
  3. Complete the form by entering your "Username", "Password", "Host", "Port" and "Database key".
  4. Create your query using your favorite editor, and paste it in the field labeled “Query.
  5. If you would like other members to edit the query only. Select “Allow team members to edit the above query.”
  6. If you want Graphext to write back the project's output to SQL Server. Select “Allow write output.” View more documentation about this step here.
  7. Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.

Azure SQL

How to Connect an Azure SQL database?

  1. Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on.
  2. Select “Azure SQL” from the integrations list.
  3. Complete the form by entering your "Username", "Password", "Host", "Port" and "Database key".
  4. Create your query using your favorite editor, and paste it in the field labeled “Query.
  5. If you would like other members to edit the query only. Select “Allow team members to edit the above query.”
  6. If you want Graphext to write back the project's output to Azure SQL. Select “Allow write output.” View more documentation about this step here.
  7. Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.

Amazon S3

How to Connect an Amazon S3 Bucket?

  1. Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on.
  2. Select “Amazon S3” from the integrations list.
  3. Head to the AWS webpage and click on Security Credentials, which you will find in the dropdown in the top right corner.
  4. Copy the Access Key ID, and paste it into the corresponding field.
  5. Copy your “Secret Access Key” (in case you don’t find it; below we explain how to generate one), and paste it into the field labeled “AWS Secret.
  6. Use the “Region name” dropdown to select the AWS region name of your bucket.
  7. Copy the “Bucket Name" in the Buckets tab and paste it into the corresponding field.
  8. Enter the desired bucket, and copy the file path you want to connect to. If you have folders inside the bucket, follow this format “folder/example_dataset.csv”. Paste it into the “Path” field.
  9. If you want Graphext to write back the project's output to Amazon S3. Select “Allow write output.” View more documentation about this step here.
  10. Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.

Create an Access Key

  1. Click on Security Credentials.
  2. Scroll down and click on Create Access Key.
  3. Save the Access Key and the Secret.

Google Cloud Storage

How to Connect Google Cloud Storage?

  1. Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on.
  2. Select “Google CS” from the integrations list.
  3. Click on “Continue with Google.
  4. Select your Google account and ”Allow” from the Google sign-in permissions window.
  5. Head to the Google Cloud webpage and open the Buckets section. Copy the name of the desired bucket, and paste it into the field labeled “Bucket Name.
  6. Open the desired bucket in Google CS, and copy the file name you want to import. Paste it in the field labeled “Source Blob Name.
  7. Copy your Project ID by clicking on the dropdown to the right of the Google Cloud logo. Paste it in the field labeled “Project ID.
  8. If you want Graphext to write back the project's output to Google CS. Select “Allow write output.”
  9. Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.

Azure Blob Storage

How to Connect a Azure Blob Storage?

  1. Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on.
  2. Select “Azure Blob Storage” from the integrations list.
  3. Head to Azure Blob Storage webpage, and select the desired Storage account.
  4. In the Security + networking tab, click on the Access Keys. Copy the Storage Account name, and paste it into the field labeled “Account Name.
  5. Copy the “Key” from Azure, and paste it into the field labeled “Account Key.
  6. Navigate to the Containers tab under the Data Storage section, copy the name of the desired container, and paste it into the corresponding field.
  7. Enter the desired container, copy the file name, and paste it into the field labeled “Blob Name.
  8. If you want Graphext to write back the project's output to Azure Blob Storage. Select “Allow write output.” View more documentation on this step here.
  9. Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.

Google Drive

How to Connect Datasets on Google Drive?

  1. Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on..
  2. Select “Google Drive” from the integrations list.
  3. Click on “Continue with Google
  4. Select your Google account and ”Allow” from the Google sign-in permissions window.
  5. Navigate to the desired file in Google Drive.
  6. Click on the three dots menu at the top right corner of the file and select “Get Link.
  7. Change the General access to Anyone with the link, copy it, and paste it into the field labeled “Shareable link.
  8. If you would like other members to edit the URL only. Select “Allow team members to edit the URL.”
  9. If you want Graphext to write back the project's output to Google Drive. Select “Allow write output.” View more documentation on this step here.
  10. Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.

Tinybird

How to Connect Tinybird?

  1. Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on.
  2. Select “Tinybird” from the integrations list.
  3. Head to the Tinybird webpage and click the “Auth tokens” section. Copy your token and paste it into the field labeled “Access Token.
  4. Copy the name of the desired pipe, and paste it into the field labeled “Pipe.
  5. If you want Graphext to write back the project's output to Tinybird. Select “Allow write output.”
  6. Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.

Google Sheets

How to Connect Google Sheets?

  1. Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on.
  2. Select “Google Sheets” from the integrations list.
  3. Click on “Continue with Google.
  4. Select your Google account and ”Allow” from the Google sign-in permissions window.
  5. Navigate to the desired file in Google Sheets.
  6. Copy the URL from the browser (not the shareable link) and paste it into the field labeled “Browser URL of the desired sheet.” Note we can only retrieve the data from the sheet you select, not all the sheets in your file.
  7. If you would like other members to edit the URL only. Select “Allow team members to edit the URL.”
  8. If you want Graphext to write back the project's output to Google Sheets. Select “Allow write output.”
  9. Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.

Notion

How to Connect Notion?

  1. Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on.
  2. Select “Notion” from the integrations list.
  3. Click on “Continue with Notion.
  4. Click on “Select Pages” from the Notion’s permissions window.
  5. Navigate and select the pages you want and click on the Allow access button.
  6. Head to Notion, go to the three dots menu on top of the database you want to import, select  “Link to view” and paste it into the field labeled “Link to the database view
  7. If you want Graphext to write back the project's output to Notion. Select “Allow write output.”
  8. Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.

Existing Integrations

Edit integrations

Once you have configured your integration, you can modify some of the fields, rename it, or even delete it. To access the edit modal, you first need to access the list of existing integrations. There are two ways to do this:

  1. Click on the "New Project" button, and on the left-hand side, you will see the "Existing Integrations" section.
  2. In the top left corner, you will see the number of existing integrations. Click on it to access the modal to manage the "Existing Integrations".

From this list of integrations, you can edit existing integrations, and you can also create a new project using the same integration.

Refresh projects

One of the greatest benefits of creating a project from an integration is being able to update it with new data without needing to import them again. To update the project, you have two options:

From the hall, where you have a view of all the cards of your projects, you can hover over the project with the integration, click on the three vertical dots, and then click on "update project".

Within the project, in the data section, you will find an icon with two circular arrows on the top left of the table. Clicking on this icon will update the project with the latest data.

Need Something Different?

We know that data isn't always clean and simple.
Have a look through these topics if you can't see what you are looking for.