Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio 17.0 introduces support for Google BigQuery, a RESTful web service that enables interactive analysis of very large datasets. With this release, you can now register server connections to Google BigQuery, select your projects, run SQL queries against BigQuery datasets, and quickly analyze and gain real-time insights about your data. We are providing a full set of tools for BigQuery to make this speed-optimized data analysis offering in the cloud even more efficient to use. Our Query Analyzer, Query Builder, Import/Export tools, Visual Analytics, ER Modeler, Compare Tools, plus many other features are available for BigQuery. These functionalities let you take full advantage of the simple, fast, and scalable architecture of BigQuery.
Sign up for BigQuery and create your Projects. Launch the Register Server dialog and create a native connection to Google BigQuery using the standard Google Authentication. Use Aqua Data Studio to access your data using the Query Analyzer. Easily browse or create tables, run queries, import/export data to Google Cloud Storage, and perform querying and scripting tasks in our tool.
Script a BigQuery object as SELECT, INSERT, CREATE or DROP to have Aqua Data Studio generate DML and DDL statements. With the Schema Script Generator, you can either choose objects to script or script the complete content of a Dataset.
Explore your Google BigQuery Projects, Datasets, and Tables by using the Schema Browser. Schema Browser is a visual tree that shows the contents of all of your Schema Objects. Projects are top-level containers in Google Cloud Platform. Use the Schema Browser to create or remove objects, or view object properties.
BigQuery caches query results on a best-effort basis for increased performance. Results are cached for 24 hours and cached queries are subject to the same quota policies as non-cached queries. Aqua Data Studio displays the cache hit and total byte processed after executing a query in the Query Analyzer. Users can easily determine whether the cache was used for the query execution.
Connect to Google BigQuery and execute SQL queries effortlessly by using intelligent Autocomplete, SQL Abbreviations, and SQL Automation. Perform advanced analysis by using the built-in Pivot Grid and Charts, or one-click export to Excel feature.
Learn more
Quickly create Google BigQuery Datasets, Tables, and Views through Aqua Data Studio's highly streamlined Visual Editing UI. Drop objects just as easily.
Learn more
Use our UI's built-in ETL functionality to import data, configure it to suit your needs, and export it in a different format. Use Aqua Data Studio's wizards to walk you through, step by step, importing data into existing Google BigQuery tables and exporting Google BigQuery data based on your desired format.
Learn more
Script a complete Google BigQuery project to file, including CREATE, DROP DDL, and INSERT DML without typing an SQL command. Save the generated scripts for later or share them with coworkers.
Learn more
Create and manage Google BigQuery ER diagrams. From a simple reverse engineering of your existing database to designing a highly complex diagram involving thousands of entities, you can annotate, forward engineer, perform diffs, generate HTML reports and much more.
Learn more
Construct sophisticated database queries without writing a line of SQL. Use our UI to select tables and columns and leverage our rich set of visual options including JOINs, GROUP BYs, SORT ORDER, equality comparisons, and more.
Learn more
Use Open APIs to create fully automated end-to-end solutions for your Google BigQuery databases using JavaScript. Aqua Data Studio provides a full-fledged IDE with APIs to Google BigQuery database access, schema DDL generation, Grid and Pivot Grid charts, version control, and much more.
Learn more
Generate great looking charts and graphs from your Google BigQuery database content. Choose from a variety of chart types and customize the way you want to visualize your data. Visual Analytics gives you a clear picture of what your data means.
Learn more
Generate charts and graphs from your Google BigQuery database content. Choose from a variety of chart types and customize the way you want to visualize your data. All charts are updated in real time based on your query results. You can even pivot your data and create charts based on your pivoted data.
Learn more
Automate your database ETL tasks using FluidShell, which is an interactive shell that combines the power of an SQL command line with the versatility of a UNIX shell.
Learn more
Use the Schema Compare tool to quickly determine the differences between Google BigQuery objects. Generate HTML reports of the comparison results.
Learn more
After generating results from a query, use the Results Compare Tool to search, filter and sort differences. Generate and share HTML reports of the comparison results.
Learn more
Automatically record and archive all queries that you run on Google BigQuery, or store them in a centralized location for auditing purposes. View a history of all the SQL statements and scripts that have been executed within the Query Analyzer and Query Builder. Execute a query from months or even years ago.
Learn more