graph-studio

Connecting to Databricks

The following properties can be specified when loading data from a Databricks connection.

Not all properties listed here may be necessary when creating the data connection. However, at a minimum, basic information must be provided.

Basic Information

Title - The name of the connection.
Description - The description (optional) of the connection.
Host - The IP address or host name of the storage system.
Port - The network port number through which the storage system connects.
Path - The path to a database file to use for this connection.
Username - The user account used to authenticate access to the storage system.
Password - The password corresponding to the user account.
Enable SSO - Specifies whether to use the SSO context of the interactive user (when available) to execute requests.

Async Exec Poll Interval
Auth Mech
Automatic Column Rename
Catalog Schema Switch
Decimal Column Scale - The number of digits to the right of the decimal point used when mapping or creating DECIMAL or NUMERIC columns.
Default String Column Length - The default maximum character length assigned to string or VARCHAR columns when no explicit size is provided.
Delegation Token
Delegation UID
DNS Resolver
DNS Resolver Arg
Fast Connection
KRB JAAS File - The path to the Java Authentication and Authorization Service (JAAS) configuration file used for Kerberos authentication with Databricks.
Non SS Ps
Prepared Meta Limit Zero
Rows Fetched per Block - The number of rows retrieved in a single network round-trip during query.
Server Version - The Databricks SQL or database engine version to connects to.
Service Discovery Mode - The mode by which the client locates the Databricks service endpoint.
Socket Factory
Socket Factory Arg
Socket Timeout - The maximum time (in milliseconds or seconds) the client waits for a response over an established socket connection before aborting.
SSL
Strip Catalog Name
Use Custom Type Coercion Map
Use Native Query

Maximum Allowed Concurrency - The overall limit on concurrent executions used to process the source.
Number of Nodes - The number of nodes to use when processing the source.
Executors per Node - The number of executors to use per node when processing the source.
Maximum Request Rate - The maximum aggregate request rate against the source (e.g., 100 / s, 480 / minute).

Locale - The locale to use when parsing dates and numbers (e.g., ar-SA, en-US, ja-JP).
Character Encoding - The default character encoding used by the connection (e.g., EBCDIC, UTF-8).
Timezone - The timezone to use for dates and times that don't contain one (e.g., GMT+2, PST).

Recognize only the configured formats - Specifies whether only those formats configured here should be recognized.
DateTime Formats - How date and time values should be encoded (e.g., yyyy-MM-dd'T'HH:mm:ss, MM/dd/yyyy HH:mm, dd-MMM-yyyy HH:mm:ss).
Date Formats - How calendar dates without time information should be encoded (e.g., yyyy-MM-dd, MM/dd/yyyy, dd-MMM-yyyy).
Time Formats - How time-of-day values should be encoded (e.g., HH:mm:ss, hh:mm a, HH:mm:ss.SSS).
Boolean Formats - How true/false or binary logical values should be encoded (e.g., true/false, 1/0, Y/N).
Double Formats - How double-precision floating values should be encoded (e.g., ##,##0.00, $, %).
Float Formats - How single-precision floating-point values should be encoded (e.g., ##,##0.00, %, e).
Integer Formats - How whole numbers should be encoded (e.g., #, #,###,##0).
Long Formats - How long integer values exceeding the range of standard integers should be encoded (e.g., #, #,###,##0).
Month Formats - How standalone month values should be encoded (e.g., MM, MMMM).
Year Month Formats - How combined month and year values should be encoded (e.g., yyyy MM, yyyy-MMM).
Month Day Formats - How combined month/day values should be encoded (e.g., MM-dd, MMM dd, MM/dd)
Year Formats - How standalone year values are encoded (e.g., yyyy, YY).