Skip to main content

New level of functionality and performance in data access via Python

Project description

Python Connector for Google BigQuery

Python Connector for Google BigQuery is a connectivity solution for accessing the Google BigQuery data warehouse from Python applications. It fully implements the Python DB API 2.0 specification. The connector is distributed as a wheel package for Windows and Windows Server.

GoogleSQL for BigQuery

The connector fully supports the BigQuery SQL dialects, data types, and query syntax, including functions, operators, and conditional expressions. Examples of supported BigQuery functions:

  • Aggregate functions
  • Array functions
  • Datetime functions
  • Navigation functions

Using the connector

To retrieve data from a database:

Import the module.

import devart.bigquery

Connect to a database using the connect() module method and obtain a connection object: If you have a refresh token, pass it in the connection string.

my_connection = devart.bigquery.connect(
    ProjectId="your_project_id;",
    DataSetId="your_dataset_id",
    RefreshToken="your_refresh_token"
)

If you don't have a refresh token, obtain it in the following way.

response = devart.bigquery.signin()
my_connection = devart.bigquery.connect(
    ProjectId="your_project_id",
    DataSetId="your_dataset_id",
    RefreshToken=response["Refresh Token"]
)

Create a cursor object using the cursor() connection method.

my_cursor = my_connection.cursor()

Execute the SQL statement using the execute() cursor method.

my_cursor.execute("SELECT * FROM employees")

Retrieve the result set using one of the fetch*() cursor methods.

for row in my_cursor.fetchall(): 
    print(row)

Ordering and activating the license

You can purchase a license for the connector on the ordering page:
https://www.devart.com/python/bigquery/ordering.html

To activate the license, follow the instructions in the documentation:
https://docs.devart.com/python/bigquery/activate-a-license.htm

What's new

Python Connector for Google BigQuery 1.2

  • Added support for Python 3.13

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

devart_bigquery_connector-1.2.0-cp313-cp313-win_amd64.whl (5.6 MB view details)

Uploaded CPython 3.13 Windows x86-64

devart_bigquery_connector-1.2.0-cp313-cp313-win32.whl (5.4 MB view details)

Uploaded CPython 3.13 Windows x86

devart_bigquery_connector-1.2.0-cp312-cp312-win_amd64.whl (5.6 MB view details)

Uploaded CPython 3.12 Windows x86-64

devart_bigquery_connector-1.2.0-cp312-cp312-win32.whl (5.4 MB view details)

Uploaded CPython 3.12 Windows x86

devart_bigquery_connector-1.2.0-cp311-cp311-win_amd64.whl (5.6 MB view details)

Uploaded CPython 3.11 Windows x86-64

devart_bigquery_connector-1.2.0-cp311-cp311-win32.whl (5.4 MB view details)

Uploaded CPython 3.11 Windows x86

devart_bigquery_connector-1.2.0-cp310-cp310-win_amd64.whl (5.6 MB view details)

Uploaded CPython 3.10 Windows x86-64

devart_bigquery_connector-1.2.0-cp310-cp310-win32.whl (5.4 MB view details)

Uploaded CPython 3.10 Windows x86

devart_bigquery_connector-1.2.0-cp39-cp39-win_amd64.whl (5.6 MB view details)

Uploaded CPython 3.9 Windows x86-64

devart_bigquery_connector-1.2.0-cp39-cp39-win32.whl (5.4 MB view details)

Uploaded CPython 3.9 Windows x86

devart_bigquery_connector-1.2.0-cp38-cp38-win_amd64.whl (5.6 MB view details)

Uploaded CPython 3.8 Windows x86-64

devart_bigquery_connector-1.2.0-cp38-cp38-win32.whl (5.4 MB view details)

Uploaded CPython 3.8 Windows x86

devart_bigquery_connector-1.2.0-cp37-cp37m-win_amd64.whl (5.6 MB view details)

Uploaded CPython 3.7m Windows x86-64

devart_bigquery_connector-1.2.0-cp37-cp37m-win32.whl (5.4 MB view details)

Uploaded CPython 3.7m Windows x86

File details

Details for the file devart_bigquery_connector-1.2.0-cp313-cp313-win_amd64.whl.

File metadata

File hashes

Hashes for devart_bigquery_connector-1.2.0-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 d6318ff3c567ce34d29c8bf07a11bf3ffeed384b3f572d1ee8bb0f943ff99831
MD5 2b1a9fd4cdd6fc8a8d1f499ffb59720a
BLAKE2b-256 7e02648e050218f07f71238589c75ea24f22ddc970c95663a22dd0dbd7d77684

See more details on using hashes here.

File details

Details for the file devart_bigquery_connector-1.2.0-cp313-cp313-win32.whl.

File metadata

File hashes

Hashes for devart_bigquery_connector-1.2.0-cp313-cp313-win32.whl
Algorithm Hash digest
SHA256 045102ee522558850ea4ea84d77cf78038e485b298e1928dd18c8f9f544112e6
MD5 8ec31634e88ec0e502c979d25b2aaaec
BLAKE2b-256 01a487e77968c8462e863fd7fd7c293823a247466030d80728bb9d20af108c80

See more details on using hashes here.

File details

Details for the file devart_bigquery_connector-1.2.0-cp312-cp312-win_amd64.whl.

File metadata

File hashes

Hashes for devart_bigquery_connector-1.2.0-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 82476166c55053e138a5e88026dac37b107ada37d84e447c64180c34098c3609
MD5 451c99e60f10109cc866635a2ee8caf8
BLAKE2b-256 d6d0416d40967aa324957c830800ed6bdc52f104e1e3a17497b27f9297ef6d2d

See more details on using hashes here.

File details

Details for the file devart_bigquery_connector-1.2.0-cp312-cp312-win32.whl.

File metadata

File hashes

Hashes for devart_bigquery_connector-1.2.0-cp312-cp312-win32.whl
Algorithm Hash digest
SHA256 9db2528379b437d40224f6d7c6c4844187bfff8aad0c8544b516201ffa1281b3
MD5 710cacba051a21b49bd18d5b5cd7c4dd
BLAKE2b-256 08cb54679e4285ad234e40f18c49fa9ef6c36121d44083c69c4f17d4ddc601e5

See more details on using hashes here.

File details

Details for the file devart_bigquery_connector-1.2.0-cp311-cp311-win_amd64.whl.

File metadata

File hashes

Hashes for devart_bigquery_connector-1.2.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 7bf3f6f235d334b7759b3a42f1879d463532f5701c0c520c79b2c9069209a0bc
MD5 389bbcbdaf6333d61f770dfc07c7fd62
BLAKE2b-256 c6f7eaf7a61c2865d06d8fed4cdb09d18ab5e51d6760d4a4ee89f73235031004

See more details on using hashes here.

File details

Details for the file devart_bigquery_connector-1.2.0-cp311-cp311-win32.whl.

File metadata

File hashes

Hashes for devart_bigquery_connector-1.2.0-cp311-cp311-win32.whl
Algorithm Hash digest
SHA256 8ad1609928c34a56222e81e81584c2f7bdee1e8f32665b4e0db4b4e3b6e0818d
MD5 4f2769d1be794537d4c46bb864cc2cef
BLAKE2b-256 d67d4efab5028ba657ae72b4256c5bb2bf7b3baf1c321710ca5d9a7371b47e01

See more details on using hashes here.

File details

Details for the file devart_bigquery_connector-1.2.0-cp310-cp310-win_amd64.whl.

File metadata

File hashes

Hashes for devart_bigquery_connector-1.2.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 cc6267cce2d7a2136c51d8c2a5fa00b0322c8f9fa42d92a83875bc4977b335bb
MD5 cdd8a044ce51a2ab8b08e8f0bde4e4cf
BLAKE2b-256 5b0273e3ce70425d8fd29a0a89fb6c2068ab59d8b9b4ed2f5b7e82ff185ed0c5

See more details on using hashes here.

File details

Details for the file devart_bigquery_connector-1.2.0-cp310-cp310-win32.whl.

File metadata

File hashes

Hashes for devart_bigquery_connector-1.2.0-cp310-cp310-win32.whl
Algorithm Hash digest
SHA256 ce598498bb6f716670d8796c72db0d126c864e80a2c0b78bb77c3ac8434be514
MD5 85d796c26a5cbb70671534d4a47d63dc
BLAKE2b-256 0c70149e3abfe391a8c4e669c4d1a80c4af43576e3194e82aed4c65650cb7ddb

See more details on using hashes here.

File details

Details for the file devart_bigquery_connector-1.2.0-cp39-cp39-win_amd64.whl.

File metadata

File hashes

Hashes for devart_bigquery_connector-1.2.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 959444a556c7835c3bd1474499e15cb1f5a591a5aef09771d3245405a0387044
MD5 454c369571f39dae067c9da7f5c885f0
BLAKE2b-256 caf1af158920fe94d660eadc3b0e825b5a34465ac30ee24e5595ea096c795c13

See more details on using hashes here.

File details

Details for the file devart_bigquery_connector-1.2.0-cp39-cp39-win32.whl.

File metadata

File hashes

Hashes for devart_bigquery_connector-1.2.0-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 5965a9824a4c620de0dd544b42e20126adfcde83f16573e0da4a1ea42d65d3de
MD5 d42741e4ed9afc35e2c5a264006f6c4d
BLAKE2b-256 f3ab659fd6977516073c48516adba01c185cf40567f230d9da7cf61de2c29b5b

See more details on using hashes here.

File details

Details for the file devart_bigquery_connector-1.2.0-cp38-cp38-win_amd64.whl.

File metadata

File hashes

Hashes for devart_bigquery_connector-1.2.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 b2a845a102259d512cd572233671f9cfc45319727f3d5091b85e868fe31b9a91
MD5 ea5c7f7fcfdf27c9a509ef5259c0bd69
BLAKE2b-256 718a3da2c75dcd6caaa04a446b5372b515d4ade9b1cdb3a2b146c45fa3c3a2ef

See more details on using hashes here.

File details

Details for the file devart_bigquery_connector-1.2.0-cp38-cp38-win32.whl.

File metadata

File hashes

Hashes for devart_bigquery_connector-1.2.0-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 c382c0ed0f99248b9ab8ca515e09e59e06a96b5509fdd42c08a951924c62d59f
MD5 017b672c59613a53980cbe7ca4cd1736
BLAKE2b-256 12ec69916e824dae8d5571745bfd1cb46de35742ad4f3e6ee792e1b3e2cdfa6c

See more details on using hashes here.

File details

Details for the file devart_bigquery_connector-1.2.0-cp37-cp37m-win_amd64.whl.

File metadata

File hashes

Hashes for devart_bigquery_connector-1.2.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 8821ad94b774be22b953f20c4b6b80b0d3b9f1a8a70f0e1c7e1f91c5bc2eadc4
MD5 b2b75ecc7e0871a5fda7ac527ca706a7
BLAKE2b-256 c4c2eb37ccc1b78e72d9117ffefbf337f86b1785117743b6ddc54f2cd2ded1b1

See more details on using hashes here.

File details

Details for the file devart_bigquery_connector-1.2.0-cp37-cp37m-win32.whl.

File metadata

File hashes

Hashes for devart_bigquery_connector-1.2.0-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 fe5c055624e9a29f644e08a75c02546804972d4250b3ac0d6ca8e42d978a3a1e
MD5 e3157c01107bb32f8cc10274153236fd
BLAKE2b-256 6d04fc9310b4d40829ec4937ac44c9dcdf6fc50b5162312194bc4c1197cd4a5a

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page