Starburst
Connection Type | ODBC (64-bit) |
Driver Details | For information on Database ODBC Driver, see Starburst Documentation. |
Type of Support | Read & Write |
Validated On | Database Version:
ODBC Driver Version: 2.01.10.1014 |
Alteryx Tools Used to Connect
Standard Workflow Processing
Authentication Methods Supported
For standard workflow processing:
Username and password
Generic OAuth
Read and Write Support with DCM Connection
Drop the Input tool or the Output tool onto the canvas.
Select Use Data Connection Manager (DCM) and Set Up a Connection.
Locate Starburst on the list of data sources and select Quick Connect.
Once you have selected Quick Connect, you will see a list of input parameters required to set up a new connection.
Fill out the details and save the connection.
Next, select Add credentials and choose an authentication method. Provide the required details, and save and link your credentials with the connection.
Select Connect.
Starburst Bulk Loader
Alteryx Designer currently supports writing to Starburst only through single INSERT statements, which can be inefficient for large datasets. The bulk loader improves performance by:
Uploading data to a Starburst-specific staging location
Running a
COPY INTOstatement in Starburst to load the data into a target table
This method is faster and more efficient for large data loads.
Follow the steps below to use a bulk loader to write data to Starburst:
Drag the Write Data tool onto the canvas and select the Bulk option for Starburst.
Enter the required Starburst connection details, such as host, port, and credentials.
Configure the target table and staging location.
Run the workflow:
The data is first uploaded to the Starburst staging location.
Then loaded into the target table using a COPY INTO statement.
Data is successfully loaded into Starburst with improved performance compared to single INSERT statements.