JDBC / ODBC Connection

Ascend exposes an interface compatible with standard JDBC and ODBC to query data in any Component in a Dataflow. Unlike the Ascend Structured Data Lake which exposes bulk retrieval of all records in a component, this interface allows users to run a SQL query, which is evaluated in Ascend, and retrieve particular the results of that query.

This interface is most often used with BI Tools, like Looker and Tableau, or when access to a particular slice of a Component's records is desired.

Connection Details

Ascend performs a mapping where each Data Service + Dataflow is available as a 'schema' and each Component is a 'table'. The mapping uses each entity's ID.

The SQL syntax is standard Spark SQL.

Depending on the Service Account's permission, Read Only will allow access to all components while Data Feed Read Only will only map Data Feeds.

Parameter

Value

Host name

ascend-subdomain.sql.ascend.io

Port

10000

SSL

Must be Enabled

Username / Password

The Username + Password from an API Token tied to a Service Account

JDBC / ODBC Protocol

Spark SQL (if driver is present), if not Hive 2.3.7 is compatible

Updated 10 days ago


JDBC / ODBC Connection


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.