QuickBase

Connectivity Summary

An out-of-the-box connector is available for QuickBase databases to support crawling database objects, profiling sample data, and relationships building.

The drivers used by the connector are mentioned below:

Driver/ API: API                   

Version: 1.0

Details: APIs URL

https://help.quickbase.com/api-guide/intro.html

https://developer.quickbase.com/

Technical Specifications

The following are the connector capabilities mentioned below:

Crawling

Supported objects for Crawling are:

  • Tables
  • Table Columns
 

Profiling

See this article Profile Data to know more about Profiling.

Feature Support
Table Profiling Row count, Columns count, View sample data
View Profiling Row count, Columns count, View sample data
Column Profiling Min, Max, Null count, distinct, top 50 values
Full Profiling Supported
Sample Profiling Not Supported
 
 

Lineage Building

Lineage Entities Details
Table lineage Not Yet Supported
Column lineage Not Yet Supported
Lineage Sources  

Querying 

Operation Details
Select Supported
Insert Not supported, by default.
Update Not supported, by default.
Delete Not supported, by default.
Joins within database Supported
Joins outside database Not supported
Aggregations Supported
Group By Supported
Order By Supported

By default, the service account provided for the connector will be used for any query operations. If the service account has write privileges, then Insert / Update / Delete queries can be executed.

Pre-requisites

To use the connector, the following need to be available:

  • Connection details as specified in the following section should be available.
  • An admin/service account with read privileges.

Connection Details

The following are the connection settings that need to be added for connecting to QuickBase database:

Quickbaseconnect

  • Database Type: Quickbase
  • License Type: Standard
  • Connection Name: Select a Connection name for the QuickBase database. The name that you specify is a reference name to easily identify your QuickBase database connection in OvalEdge.
    Example: Quickbase  Connection1
  • Server: Database instance URL (on-premises/cloud-based)
    Example: premanvithatatikonda.quickbase.com
  • Port number: 80
  • Username: User account login credential (only for MySql Authentication)
  • Password: Password (only for MySql Authentication)

Once connectivity is established, additional configurations for Crawling and Profiling can be specified.

Property  Details
Crawler configurations
Tables, views & columns By default, it is selected true
Relationships Need to select for crawl relationships
Crawler rules Default includes tables regex has  regex = (.*), which can crawl all the tables
Profile Settings
Tables and columns By default, it is selected true
Views and columns By default, it is selected true
Profile Rules Default includes tables regex has  regex = (.*), which can profile all the tables