Link Search Menu Expand Document

Connect to Soda Cloud

To use the Soda Cloud web application to monitor your data, you must install and configure the Soda SQL command-line tool, then connect it to your Soda Cloud account.

Soda SQL uses an API to connect to Soda Cloud. To use the API, you must generate API keys in your Soda Cloud account, then add them to the warehouse YAML file that Soda SQL created.

  1. If you have not already done so, create a Soda Cloud account at cloud.soda.io.
  2. Use the instructions in Install Soda SQL to install Soda SQL.
  3. Follow steps in the Quick start tutorial to create your warehouse YAML file, connect to your warehouse, analyze your tables, and run a scan on the data.
  4. Open the warehouse.yml file in a text editor, then add the following to the file:
    soda_account:
      host: cloud.soda.io
      api_key_id: env_var(API_PUBLIC)
      api_key_secret: env_var(API_PRIVATE)
    
  5. Save the warehouse.yml file.
  6. Open your ~/.soda/env_vars.yml file in a text editor, then add the following to the file:
    [warehouse_name]:
      ...
      API_PUBLIC:
      API_PRIVATE:
    
  7. In Soda Cloud, navigate to your Profile page to generate new API keys.
    • Copy the Public key, then paste it into the env_vars.yml file as the value for API_PUBLIC.
    • Copy the Private key, then paste it into the env_vars.yml file as the value for API_PRIVATE.
  8. Save the changes to the env_vars.yml file. Close the API Keys create dialog box in your Soda Cloud account.
  9. From the command-line, use Soda SQL to scan the tables in your warehouse again.
    $ soda scan warehouse.yml tables/[dbtablename].yml
    
  10. Navigate to your Soda Cloud account and refresh the browser. Review the results of your scan in Monitor Results.

Go further