Sign inTry Free

Important

Self-managed SingleStore will soon transition from version 9.1 RC to version 10. This new semantic versioning scheme will provide SingleStore with finer control over engine and feature releases that were not possible with the current versioning scheme.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10 prior to its general availability. Ahead of this transition, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 10.

Connect with Alteryx Designer

On this page

You can connect to your SingleStore database from Alteryx Designer and perform analytics operations. Alteryx supports both read and write operations for the SingleStore data source.

For standard workflow processing, Alteryx supports the following tools for the SingleStore data source:

Alteryx supports the following authentication methods for the SingleStore data source:

  • No authentication

  • Username/password

  • Generic OAuth

Prerequisites

Connect to SingleStore using a DSN and DCM

To connect to SingleStore from Alteryx using a DSN, you must create a Data Source Name (DSN) for your ODBC connection. Once the DSN is created, perform the following tasks:

  1. On the Alteryx Designer window, drag either the Input Data or Output Data tool from the tool palette to the workflow canvas area.

  2. Select the Use Data Connection Manager (DCM) check box.

  3. In the Data Connections window, select Data Sources > Singlestore ODBC. If Alteryx is unable to detect the SingleStore ODBC driver, a pop-up indicates that the driver must be installed.

  4. On the Connection Manager window, select New to add a new data source.

  5. Select ODBC from the list. This option is selected by default.

  6. Enter a Data Source Name (DSN) for the new data source, for example, Singlestore Server DSN.

  7. Select the ODBC DSN field to see a list of available DSNs, and select a DSN to use for the data source.

  8. Select Save.

  9. To link a credential, select Connect Credential and select an Authentication Method from the list.

  10. Select Connect to use the Data Source and Credential in an Input Data or Output Data tool.

Configure DSN-less Connection Using DCM

To connect to SingleStore from Alteryx using a DSN-less connection,

  1. On the Alteryx Designer window, drag either the Input Data or Output Data tool from the tool palette to the workflow canvas area.

  2. Select the Use Data Connection Manager (DCM) check box.

  3. In the Data Connections window, select Data Sources > SingleStore Quick Connect. If Alteryx is unable to detect the SingleStore ODBC driver, a pop-up indicates that the driver must be installed.

  4. On the Connection Manager window, select New to add a new data source.

  5. Select Singlestore ODBC DSN-less from the list. This option is selected by default.

  6. Enter the following connection configuration information:

    • Data Source Name for the connection, for example, Singlestore DSN-less

    • Hostname or IP address of the SingleStore deployment

    • Name of the SingleStore database to connect with

    • Port of the SingleStore database

  7. (Optional) Select the Driver field to change the selected driver.

  8. Select Save.

  9. To link a credential, select Connect Credential and select an Authentication Method from the list.

  10. Select Connect to use the Data Source and Credential in an Input Data or Output Data tool.

Limitations

Alteryx does not support the following for the SingleStore data source:

  • Spatial data types

  • Table names containing ' (single quote)

  • Writing to DOUBLE type columns

  • BIT, BINARY, VARBINARY, TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB SingleStore data types

Last modified:

Was this article helpful?

On this page

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK

Try Out This Notebook to See What’s Possible in SingleStore

Get access to other groundbreaking datasets and engage with our community for expert advice.

Sign UpLog In