Auth Notes (numbered steps), documented params, Maven DriverDownloadLinks, extra SQL examples for ODBC apps. Initial version. Starburst from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

1. Note coordinator host and HTTP port (often 8080 for lab, 443 for Cloud TLS).
2. Create an application user if the cluster requires a password. Some labs allow any user with an empty password.
3. After Finish, set catalog/schema on the DSN Main UI or qualify tables as tpch.sf1.orders.
4. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
5. Done. You can query from C#, Python, PowerShell, and ODBC apps.

]]> Starburst with TLS from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

1. Same as Non-SSL Auth. Use port 443 (or your TLS port) and SSL=true.
2. Fill user and password from the coordinator or Starburst Galaxy/Galaxy-like console.
3. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
4. Done. You can query from C#, Python, PowerShell, and ODBC apps.

]]> Lists tables available to this connection. Use this in Power BI or a SQL Server Linked Server to confirm the catalog before building reports.

]]> Returns rows from tpch.sf1.orders. Replace the identifier with your catalog object. Works in Excel, SSRS, and Crystal Reports.

]]> Returns matching rows from tpch.sf1.orders.

]]> Joins two tables on a key. Use in Azure Data Factory or SSIS when you need a combined extract.

]]> Counts rows per group. Typical Power BI import pattern before a visual.

]]> Returns the first 100 rows. Useful for preview in Excel or Crystal Reports.

]]> Returns the number of rows in tpch.sf1.orders.

]]> Maps a column to labels with CASE.

]]> Returns a column list instead of star. Prefer this in Linked Server views.

]]> Keeps groups whose count is at least 1.

]]> = 1]]> Reads all records from tpch.sf1.orders. Sample catalog often shipped with Trino/Starburst labs. Use in Power BI to confirm the catalog.

]]> Reads orders with status O. Demonstrates WHERE for Excel or SSRS filters.

]]> Counts orders per priority. Typical Power BI import before a visual.

]]> Joins orders to customer. Use in Azure Data Factory or a Linked Server view.

]]> Sums order price per customer.

]]>