The CData ADO.NET Provider for Google Cloud Storage models Google Cloud Storage buckets, bucket information, and objects as a SQL database with tables, views, and stored procedures, allowing you to write SQL to query Google Cloud Storage data. Any changes you make to your buckets in the Google Cloud Storage UI, such as adding new objects or modifying bucket configurations, are automatically included in the schema of the provider.

Key Features

• The provider uses a multi-schema model, meaning that the data model is organized into separate schemas. A separate Bucket Schema is dynamically generated for each bucket and named after it, while the static Information Schema serves as the default, and has tables and views that provide both cross-bucket aggregate data and bucket-level metadata. This schema also hosts the stored procedures.
• Stored Procedures allow you to execute operations to Google Cloud Storage, including downloading and uploading objects. Because all stored procedures are located in the Information Schema, the provider always connects to both the selected Bucket Schema and the Information Schema simultaneously.

System Tables

System Tables contain information about the objects and resources belonging to your database.