Data sources, connectors & refresh — found from sitemap — Preset (Apache Superset)

Cited by

Facts read from this source

• Workspace admin required Report an error

  “Only Workspace Admins can connect databases.”

• Publicly addressable only Report an error

  “As a cloud software, Preset only connects to databases that are publicly addressable.”

• Allowlist regions Report an error

  “us-west-2 (us1a) us-east-1 (us2a) eu-north-1 (eu5a) ap-northeast-1 (ap1a)”

• Credential connection databases Report an error

  “Google BigQuery PostgreSQL Snowflake MySQL Amazon Redshift Google Sheets”

• Sqlalchemy uri connection Report an error

  “If your database is not listed above, then you can connect by providing a SQLAlchemy URI.”

• Ssl connection option Report an error

  “SSL: Select the switch to require a SSL connection.”

• Default ports Report an error

  “This fields is used when connecting Redshift (default port 5439), PostgreSQL (default port 5432), and MySQL (default port 3306) databases.”

• Test connection Report an error

  “When done, select Test Connection to see if it works”

• Database import from file Report an error

  “You also have the option of importing your database from a file.”

• Supported databases Report an error

  “Airtable Amazon Athena Amazon DynamoDB Amazon Redshift Apache Doris Apache Drill Apache Druid Apache Hive Apache Impala Apache Kylin Apache Pinot Apache Spark SQL Aurora MySQL (Data API) Aurora PostgreSQL (Data API) Azure Synapse CelerData StarRocks ClickHouse Clickhouse Connect CockroachDB CrateDB Databricks Interactive Cluster (Hive) Databricks SQL Endpoint (ODBC) Dremio ElasticSearch (OpenDistro SQL) ElasticSearch (SQL API) Exasol Firebird Firebolt Google BigQuery Google Sheets IBM db2 Microsoft SQL Server MongoDB MotherDuck MySQL Oracle PostgreSQL Presto Rockset SAP HANA SingleStore Snowflake StarRocks Teradata Trino Vertica”

• Queries run on database Report an error

  “Preset runs all queries directly on your database. No extractions or data dumps are being stored on Preset, which could lead to stale data, limited scale and speed, and security issues.”

• Cross database joins unsupported Report an error

  “Because raw data never leaves your database, cross database or cross dataset joins are not supported.”

• Filter scoping alternative Report an error

  “While cross-datasets joins are not support, scoping a filter (opens in new tab) allows one dataset to be filtered based on values from another dataset, as long as there's a column name.”

• Connection walkthroughs Report an error

  “Amazon Athena Amazon Redshift Apache Druid Aurora MySQL (Data API) Aurora PostgreSQL (Data API) Databricks Google BigQuery Google Sheets (Public) Google Sheets (Private) MySQL PostgreSQL Snowflake Trino”

Scores citing this record

• The Data Analyst Data sources, connectors & refresh
• The Data Analyst European sovereignty
• The Finance Controller Data sources, connectors & refresh
• The Finance Controller European sovereignty
• The IT Administrator Data sources, connectors & refresh
• The IT Administrator European sovereignty
• The Managing Director Data sources, connectors & refresh
• The Managing Director European sovereignty
• The SaaS Product Lead Data sources, connectors & refresh
• The SaaS Product Lead European sovereignty
• The Skeptic Data sources, connectors & refresh
• The Skeptic European sovereignty