Big Query

The BigQuery connector enables Lumenore to securely connect to Google BigQuery and analyze large-scale datasets directly. It enables users to access BigQuery tables using standard SQL, supporting both live querying and data extraction for analytics and reporting. The connector leverages Google’s scalable, serverless architecture, making it suitable for high-volume data analysis with fast performance and minimal infrastructure management.

Steps to connect:

Step 1: Navigate to Home > Connect Data > Select Big Query.

Step 2: Click Create New Connection to set up a new connection or select an existing connection to proceed.

Step 3: Provide all the required details to establish the connection.

Step 4: Click the Authorize button to allow Lumenore to access your data.

Step 5: Choose your account option and continue.

Step 6: Once the account is selected or created, a success message confirms the authorization. Provide a connection name, then continue using the connection with or without saving it.

Step 7: After saving, the connection appears in the existing connections list.

Note: When the user clicks the three dots under the Action column, the options Use This Connection, Modify, or Delete are displayed. To start using a connection directly, select the connection and click Next.

Step 8: Select the connection and click Next.

Step 9: Select the table you want to export to the Lumenore database. You can also view the data by clicking the Preview tab.

• Preview table data
  Preview table data lets you quickly view a sample of records from the selected table before proceeding.

Step 10: Click “Save Dataset” to complete data ingestion.

Step 11: Provide the Dataset name and description (optional). Click Ok.

Step 12: A “Dataset saved successfully” message is displayed. After this, the user can cancel and start using the dataset or create a schema by clicking the Create Schema option.