Note: Before you start, you will need to know the value of the AddTables property that is used to define your schema. You will still be able to connect without specifying a value, but you will not be able to query your data. You can generate a value for the property using the Configure Logical Schema tool in the Configuration Manager. See Generating connection URLs with the Configuration Manager for details.

After you have installed your driver, you can use the driver to access your data with the Interactive SQL tool. Interactive SQL supports a command line interface that allows you to connect to a data source, execute SQL statements and retrieve results for display on a terminal.

To execute commands with Interactive SQL:

  1. Start the ISQL tool. From a command line, enter the following: 
    java -jar googleanalytics4.jar --isql
  2. Enter connection properties one at a time by typing property=value, then pressing Enter. For example, to configure the ClientID property: 
    ClientID=ab123c45-def6-7g89-gh1i-m2345no67891.apps.googleusercontent.com
  3. After specifying values for your properties, type connect, then press Enter. If successful, the tool will return a confirmation message.
    Note: If you are unable to connect, you can review the URL by entering the SHOW URL command.
  4. At the ISQL> prompt, issue a SQL command to query or modify the data source; then, press Enter. For example: 
    SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES;
    Note: SQL commands must be terminated by a semi-colon.
    Note: In addition to SQL commands, the tool supports a set of proprietary commands. Type Help at the prompt for a list of supported commands and syntax.
    The results of the command are displayed in the terminal.
  5. After you are finished executing queries and commands, you can disconnect from the data source by typing the following; then, pressing Enter: 
    DISCONNECT
  6. To end the session, type exit; then, press ENTER.