In the JDBC URL field, enter a connection string as described here.In the Driver dropdown, select Snowflake, and click Next.In the Folders sidebar, click Add Data Source→Connect to Database.You can right-click the data source icon ( ) and click Edit Data Source to try a different database name. If your connection appears to succeed, but you get a "no tables found" message, then verify that you are using the correct database name in the connection UI.
When connecting using integrated security, the "driver is not configured for integrated authentication" error can be fixed by downloading a DLL file from Microsoft ( discussed here).When connecting using SSL (the default), the "PKIX path building failed" error can be avoided by adding " trustServerCertificate=true" to the end of the JDBC URL ( discussed here).Solutions to some common connection problems: For mixed-type columns, you can work around this limitation by creating a formula column with the formula =text(), and then filter on the formula column instead. Known limitation: Filtering will only work on columns with a declared data type. If your SQLite file has a different file extension, you can either rename it, or add it in Ultorg by clicking Add Data Source→Connect to Database, selecting SQLite and Next, and then replacing with the path to the file in the JDBC URL field. To show up in the file browser, the file name should end with one of the common SQLite file extensions (sqlite, sqlite3, db, sdb, db3, s3db, sl3).
Use Add Data Source→Connect to File to connect to a SQLite file. In this case the Connect to Database wizard will contain instructions. To connect to Oracle, you must first download a JDBC driver.
Or replace default with the name of another profile heading in the credentials file.įor more information about authentication options for Amazon Athena, please consult the Configuring Authentication section in Amazon's documentation (page 36). In this case, add Profile=default to the end of the JDBC URL to use the credentials stored under the heading in the credentials file. If you are authenticating with an IAM secret access key, the Access Key ID should go in the User Name field and the Secret Access Key should go in the Password field.Īlternatively you may use an AWS credentials file, typically stored at ~/.aws/credentials (where ~ is your OS home directory). You will need to replace the AwsRegion and the S3OutputLocation in the JDBC URL.