Auth Notes (numbered steps), documented params, Maven DriverDownloadLinks, extra SQL examples for ODBC apps. Initial version. Athena JDBC v3 uses IAM access keys (same idea as a Stripe secret key). Query results land in S3. Bridge then serves Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

1. Sign in to the IAM console.
2. Create (or reuse) an IAM user or role with Athena and Glue catalog permissions plus s3:GetObject / s3:PutObject on the query-results bucket.
3. Open Security credentials and create an access key. Copy Access key ID into User name and Secret access key into Password. Do not check keys into XML or TFVC.
4. In the Athena console, note Region, WorkGroup (often primary), Catalog, and the S3 output location (s3://your-bucket/prefix/).
5. After Finish, edit the JDBC URL on the DSN Main UI to replace WorkGroup, Region, Catalog, and OutputLocation.
6. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
7. 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 AwsDataCatalog.default.MyTable. Replace the identifier with your catalog object. Works in Excel, SSRS, and Crystal Reports.

]]> Returns matching rows from AwsDataCatalog.default.MyTable.

]]> 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 AwsDataCatalog.default.MyTable.

]]> 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]]> Return Route 53 Resolver query logs ordered by query_timestamp so the newest DNS queries appear first. Useful in Power BI.

]]> Search EMR step logs in default.myemrlogs for log levels. Limits to 100 matching rows.

]]> Creates planets_json over JSON in S3. Run this DDL once, then SELECT.

]]> Selects from the planets_json external table created in the previous example.

]]>