Initial JDBC Bridge catalog version. Hands-free Maven JAR download. Auth Notes and SQL examples for ODBC apps. Use Application Default Credentials when this machine is already logged in to Google Cloud (gcloud or a VM service account). Spanner JDBC is the supported client; Bridge then serves Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

  1. Open the Google Cloud Console and select (or create) a project.

  2. Create a project if needed:

    Start creating a new project in Google Cloud
  3. Enable the Cloud Spanner API for that project (APIs & Services > Enable APIs).
  4. On this Windows machine run gcloud auth application-default login, or attach a GCP service account to the host.
  5. Fill Project, Instance, and Database. Leave the JSON path empty for ADC.
  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.
]]> Service-account JSON path. Use this for unattended Linked Server, ADF, or Power BI gateway refresh.

  1. In Google Cloud Console open IAM & Admin > Service Accounts and create an account.
  2. Grant a Spanner role such as Cloud Spanner Database User (read) or a writer role if you need DML.
  3. Create a JSON key and download it to a folder only the DSN process can read. Do not put the key in the connector XML or git/TFVC.
  4. Set GOOGLE_APPLICATION_CREDENTIALS or paste the JSON file path into Credentials file.
  5. Fill Project, Instance, and Database (from Spanner Studio).
  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 MY_TABLE. Replace the identifier with your catalog object. Works in Excel, SSRS, and Crystal Reports.

]]> Returns matching rows from MY_TABLE. Swap the column and literal for your schema.

]]> 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.

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

]]> = 10]]> Returns the first 100 rows ordered by a column. Useful for preview in Excel or Crystal Reports.

]]> Returns the number of rows in MY_TABLE.

]]> Maps a column to labels with CASE.

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

]]>