{
"info": {
"author": "Gabriel Bordeaux",
"author_email": "pypi@gab.lc",
"bugtrack_url": null,
"classifiers": [
"Development Status :: 4 - Beta",
"License :: OSI Approved :: MIT License",
"Natural Language :: English",
"Operating System :: MacOS",
"Operating System :: POSIX :: Linux",
"Programming Language :: Python",
"Programming Language :: Python :: 3",
"Topic :: Database",
"Topic :: Database :: Database Engines/Servers"
],
"description": "bigquery_fdw: BigQuery Foreign Data Wrapper for PostgreSQL\n==========================================================\n\n`Pypi `__ `Build\nStatus `__\n`codecov `__ `MIT\nlicensed `__\n\nbigquery_fdw is a BigQuery foreign data wrapper for PostgreSQL using\n`Multicorn `__.\n\nIt allows to write queries in PostgreSQL SQL syntax using a foreign\ntable. It supports most of BigQuery\u2019s `data\ntypes `__ and `operators `__.\n\nFeatures and limitations\n------------------------\n\n- Table partitioning is supported. `You can use partitions in your SQL\n queries `__.\n- Queries are parameterized when sent to BigQuery\n- BigQuery\u2019s standard SQL support (legacy SQL is not supported)\n- Authentication works with a \u201c`Service\n Account `__\u201d Json private key\n\n`Read more `__.\n\nRequirements\n------------\n\n- PostgreSQL >= 9.5\n- Python 3\n\nGet started\n-----------\n\nUsing docker\n~~~~~~~~~~~~\n\nSee `getting started with Docker `__\n\nInstallation on Debian/Ubuntu\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\nDependencies required to install bigquery_fdw:\n^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n\nYou need to install the following dependencies:\n\n.. code:: bash\n\n # Install required packages\n apt-get update\n apt-get install --yes postgresql-server-dev-10 python3-setuptools python3-dev make gcc git\n\n # Install pip3\n easy_install3 pip\n\nFor PostgresSQL 9.X, install ``postgresql-server-dev-9.X`` instead of\n``postgresql-server-dev-10``.\n\nInstallation\n^^^^^^^^^^^^\n\n.. code:: bash\n\n # Install `setuptools` if necessary\n pip3 install --upgrade setuptools\n\n # Install Multicorn\n git clone git://github.com/Kozea/Multicorn.git && cd Multicorn\n export PYTHON_OVERRIDE=python3\n make && make install\n\n # Install bigquery_fdw\n pip3 install bigquery-fdw\n\nMajor dependencies installed automatically during the installation\nprocess:\n\n- `Google Cloud\n BigQuery `__\n- `Multicorn `__\n\nUsage\n-----\n\nWe recommend testing the `BigQuery client\nconnectivity `__ before trying to use the FDW.\n\nWith ``psql``:\n\n.. code:: sql\n\n CREATE EXTENSION multicorn;\n\n CREATE SERVER bigquery_srv FOREIGN DATA WRAPPER multicorn\n OPTIONS (\n wrapper 'bigquery_fdw.fdw.ConstantForeignDataWrapper'\n );\n\n CREATE FOREIGN TABLE my_bigquery_table (\n column1 text,\n column2 bigint\n ) SERVER bigquery_srv\n OPTIONS (\n fdw_dataset 'my_dataset',\n fdw_table 'my_table',\n fdw_key '/opt/bigquery_fdw/key.json'\n );\n\nOptions\n-------\n\nList of options implemented in ``CREATE FOREIGN TABLE`` syntax:\n\n+--------------------------+---------------------+---------------------+\n| Option | Default | Description |\n+==========================+=====================+=====================+\n| ``fdw_dataset`` | - | BigQuery dataset |\n| | | name |\n+--------------------------+---------------------+---------------------+\n| ``fdw_table`` | - | BigQuery table name |\n+--------------------------+---------------------+---------------------+\n| ``fdw_key`` | - | Path to private |\n| | | Json key (See `Key |\n| | | storage |\n| | | recommendations ` |\n| | | __) |\n+--------------------------+---------------------+---------------------+\n| ``fdw_convert_tz`` | - | Convert BigQuery |\n| | | time zone for dates |\n| | | and timestamps to |\n| | | selected time zone. |\n| | | Example: |\n| | | ``'US/Eastern'``. |\n+--------------------------+---------------------+---------------------+\n| ``fdw_group`` | ``'false'`` | See `Remote |\n| | | grouping and |\n| | | counting `__. |\n+--------------------------+---------------------+---------------------+\n| ``fdw_casting`` | - | See |\n| | | `Casting `__. |\n+--------------------------+---------------------+---------------------+\n| ``fdw_verbose`` | ``'false'`` | Set to ``'true'`` |\n| | | to output debug |\n| | | information in |\n| | | PostrgeSQL\u2019s logs |\n+--------------------------+---------------------+---------------------+\n| ``fdw_sql_dialect`` | ``'standard'`` | BigQuery SQL |\n| | | dialect. Currently |\n| | | only ``standard`` |\n| | | is supported. |\n+--------------------------+---------------------+---------------------+\n\nMore documentation\n------------------\n\nSee `bigquery_fdw documentation `__.\n\n\n",
"description_content_type": "",
"docs_url": null,
"download_url": "",
"downloads": {
"last_day": -1,
"last_month": -1,
"last_week": -1
},
"home_page": "https://github.com/gabfl/bigquery_fdw",
"keywords": "",
"license": "MIT",
"maintainer": "",
"maintainer_email": "",
"name": "bigquery-fdw",
"package_url": "https://pypi.org/project/bigquery-fdw/",
"platform": "",
"project_url": "https://pypi.org/project/bigquery-fdw/",
"project_urls": {
"Homepage": "https://github.com/gabfl/bigquery_fdw"
},
"release_url": "https://pypi.org/project/bigquery-fdw/1.5/",
"requires_dist": [
"argparse",
"google-cloud-bigquery (==1.3.0)",
"google-auth (==1.5.0)",
"google-auth-oauthlib (==0.2.0)"
],
"requires_python": "",
"summary": "BigQuery Foreign Data Wrapper for PostgreSQL",
"version": "1.5"
},
"last_serial": 3979082,
"releases": {
"1.0": [
{
"comment_text": "",
"digests": {
"md5": "c6a1426bc412cd224684ad3c4acd764b",
"sha256": "f1087f5d28e6763a8afd51c2feb376185f5093d5e16bc5633483360193eff099"
},
"downloads": -1,
"filename": "bigquery_fdw-1.0-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "c6a1426bc412cd224684ad3c4acd764b",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 10576,
"upload_time": "2017-10-04T01:37:09",
"url": "https://files.pythonhosted.org/packages/e7/6a/f72cff8ea3a42d7f835c81f5d8876405f743ec02f563224289045df59bd8/bigquery_fdw-1.0-py2.py3-none-any.whl"
},
{
"comment_text": "",
"digests": {
"md5": "5cceaa8d4e315a1f59d86291fca93503",
"sha256": "8eb514c0ca59d86efcde440f8faf13e94d8ab4aafac6cf8788543840850f7f57"
},
"downloads": -1,
"filename": "bigquery_fdw-1.0.tar.gz",
"has_sig": false,
"md5_digest": "5cceaa8d4e315a1f59d86291fca93503",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 7393,
"upload_time": "2017-10-04T01:37:11",
"url": "https://files.pythonhosted.org/packages/2b/1e/3dc15127b22c2fdf91f6be2195eddd6ff3bdf4431ae6436b433edb24ed64/bigquery_fdw-1.0.tar.gz"
}
],
"1.0.1": [
{
"comment_text": "",
"digests": {
"md5": "90ee26300fed6ed717288a2b7aee77fb",
"sha256": "0c40b1b2d3589aecf045107dee5b208e27d70ec4beee8d96ad89f47eae7a56e9"
},
"downloads": -1,
"filename": "bigquery_fdw-1.0.1-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "90ee26300fed6ed717288a2b7aee77fb",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 10611,
"upload_time": "2017-10-04T01:53:09",
"url": "https://files.pythonhosted.org/packages/61/5a/cabdb76a5217db4cf34c89c0aaac4a94ef81ab04bec347275329f2192d31/bigquery_fdw-1.0.1-py2.py3-none-any.whl"
},
{
"comment_text": "",
"digests": {
"md5": "a5422843c0b2985048d3235ef20e2ec9",
"sha256": "66c13f2d96a26cad242541ed378b0b99a37bc515163c05494061284112832dd9"
},
"downloads": -1,
"filename": "bigquery-fdw-1.0.1.tar.gz",
"has_sig": false,
"md5_digest": "a5422843c0b2985048d3235ef20e2ec9",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 7402,
"upload_time": "2017-10-04T01:53:10",
"url": "https://files.pythonhosted.org/packages/68/5f/ed2ee5c8c62ac18ec115108034fe9f75a7cf9295a29efda72717495a2702/bigquery-fdw-1.0.1.tar.gz"
}
],
"1.0.2": [
{
"comment_text": "",
"digests": {
"md5": "ee5efda5ea816b1035bf29ca0b81a8c6",
"sha256": "eaf0a017222b2ecb246bb2cf7115c7727c5ace86f020f79f5849249552e18ee1"
},
"downloads": -1,
"filename": "bigquery_fdw-1.0.2-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "ee5efda5ea816b1035bf29ca0b81a8c6",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 10637,
"upload_time": "2017-10-04T02:02:54",
"url": "https://files.pythonhosted.org/packages/2a/46/d0ad7149ed76e69d2eaf67d7fb2759cb652453d503e565a563d4f840b4f6/bigquery_fdw-1.0.2-py2.py3-none-any.whl"
},
{
"comment_text": "",
"digests": {
"md5": "6030f32695ecdffead7f8e346bc208d9",
"sha256": "d3838b4d36740dfe8cfbc8e777ed07b6305c80c10bb513cb90b3ff2a51820e9b"
},
"downloads": -1,
"filename": "bigquery-fdw-1.0.2.tar.gz",
"has_sig": false,
"md5_digest": "6030f32695ecdffead7f8e346bc208d9",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 7425,
"upload_time": "2017-10-04T02:02:56",
"url": "https://files.pythonhosted.org/packages/1f/3a/fcb19abdcb823e50f94a427ef483d6a35cae726cd9d965c60b5854a192fd/bigquery-fdw-1.0.2.tar.gz"
}
],
"1.1": [
{
"comment_text": "",
"digests": {
"md5": "7c781cad1cff7e4feec6ae631ea88627",
"sha256": "3d8a10475c5645abc58797d262566eb64d8e44eb9e42016a93acee871564ff50"
},
"downloads": -1,
"filename": "bigquery_fdw-1.1-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "7c781cad1cff7e4feec6ae631ea88627",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 11549,
"upload_time": "2017-10-05T18:04:08",
"url": "https://files.pythonhosted.org/packages/37/98/b96448ac1d153417c8f6ef7903051fddb01b7e8cda9be94c60660920bf61/bigquery_fdw-1.1-py2.py3-none-any.whl"
},
{
"comment_text": "",
"digests": {
"md5": "8ba1ac283649b16a74666b50f8958f07",
"sha256": "ea443a53b605ce7a272f0700e143dc5b45ea98d096e7e1a655d1b2f91f3baecd"
},
"downloads": -1,
"filename": "bigquery-fdw-1.1.tar.gz",
"has_sig": false,
"md5_digest": "8ba1ac283649b16a74666b50f8958f07",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 8270,
"upload_time": "2017-10-05T18:04:09",
"url": "https://files.pythonhosted.org/packages/ed/6d/c27e1803be7236b58e1cb8b76892127bff2ca87debb7be87b10ed40fa6d2/bigquery-fdw-1.1.tar.gz"
}
],
"1.2": [
{
"comment_text": "",
"digests": {
"md5": "35567df62a6662a80b84ef0363573c72",
"sha256": "ba7d5511c0052b858c6a2ef1937f8dc5db2928acf40154433ae5e5e1f2a6ff34"
},
"downloads": -1,
"filename": "bigquery_fdw-1.2-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "35567df62a6662a80b84ef0363573c72",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 12107,
"upload_time": "2017-10-17T18:03:07",
"url": "https://files.pythonhosted.org/packages/f3/fb/8b734198779765845fbf3bdd26d767fc9beecae31f849f3a586fd6b85bb3/bigquery_fdw-1.2-py2.py3-none-any.whl"
},
{
"comment_text": "",
"digests": {
"md5": "4c8c70c2240709c3ecda38c2a6b9ba57",
"sha256": "061e33a6f58a3a174877f1d6bc91338b047c43aae5f9884fb5285bb4d78b9a88"
},
"downloads": -1,
"filename": "bigquery-fdw-1.2.tar.gz",
"has_sig": false,
"md5_digest": "4c8c70c2240709c3ecda38c2a6b9ba57",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 8947,
"upload_time": "2017-10-17T18:03:08",
"url": "https://files.pythonhosted.org/packages/eb/b0/d84e29c5d4af952953abaf1308f28da5ccff1de24e9e1966ff23af3e41da/bigquery-fdw-1.2.tar.gz"
}
],
"1.3": [
{
"comment_text": "",
"digests": {
"md5": "abcc3ff7a8833e78e5364a79a32c690a",
"sha256": "97f0cefc4bbc4cc145fdb24a572738aae71be6b26d76b1179b3756f5638b63cd"
},
"downloads": -1,
"filename": "bigquery_fdw-1.3-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "abcc3ff7a8833e78e5364a79a32c690a",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 12307,
"upload_time": "2017-11-14T19:43:40",
"url": "https://files.pythonhosted.org/packages/ab/3a/69376b7a4734f468e524ed25515bd94048c6ace97c3ee1b683d8e379636f/bigquery_fdw-1.3-py2.py3-none-any.whl"
},
{
"comment_text": "",
"digests": {
"md5": "7912ec67aee1593d2964db55c9533a5e",
"sha256": "df9acf313649f38ec66ec402e324d14f062691e3a490abb5e0ddf0d783cb6117"
},
"downloads": -1,
"filename": "bigquery-fdw-1.3.tar.gz",
"has_sig": false,
"md5_digest": "7912ec67aee1593d2964db55c9533a5e",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 9000,
"upload_time": "2017-11-14T19:43:43",
"url": "https://files.pythonhosted.org/packages/5a/66/7bf25a8bd4dce89bbec844f2b1d0c24ac828e2e6a1d0988471dc7a63c001/bigquery-fdw-1.3.tar.gz"
}
],
"1.3.1": [
{
"comment_text": "",
"digests": {
"md5": "790f333c48a3a7b0cf0bfe4d98acbc16",
"sha256": "323c110271498ea125a0622651520e1423341fa069f91e92f9092c266f31cfa0"
},
"downloads": -1,
"filename": "bigquery_fdw-1.3.1-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "790f333c48a3a7b0cf0bfe4d98acbc16",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 12351,
"upload_time": "2018-01-16T16:57:52",
"url": "https://files.pythonhosted.org/packages/b8/c9/4ed6dda7ee35b9ebf19e30acdd418239f2f7b68218d29c48a05fc82650b3/bigquery_fdw-1.3.1-py2.py3-none-any.whl"
},
{
"comment_text": "",
"digests": {
"md5": "c7e6c2dc16f3e1308c7dc5b805c6855e",
"sha256": "c592ea6a2000d48bf538341321999f2dab75db27cea86d31eed0ec16f06a8ab4"
},
"downloads": -1,
"filename": "bigquery-fdw-1.3.1.tar.gz",
"has_sig": false,
"md5_digest": "c7e6c2dc16f3e1308c7dc5b805c6855e",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 9032,
"upload_time": "2018-01-16T16:57:53",
"url": "https://files.pythonhosted.org/packages/1c/22/344fca6ac2661542ef02cd2dd669fd0751c89734406d96a32913cff01024/bigquery-fdw-1.3.1.tar.gz"
}
],
"1.3.2": [
{
"comment_text": "",
"digests": {
"md5": "a3beb00adeaa2f13d9bedb4c8d912884",
"sha256": "33bbb7ec07d6dcdd92462d36a13d40ca504764e1d8e1d6664ab2cd13932d8599"
},
"downloads": -1,
"filename": "bigquery_fdw-1.3.2-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "a3beb00adeaa2f13d9bedb4c8d912884",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 11365,
"upload_time": "2018-05-11T16:05:03",
"url": "https://files.pythonhosted.org/packages/09/a7/3a4e11d1a2668f81ce355f6701c21af0a986921a4c616a273b014ac0fa3c/bigquery_fdw-1.3.2-py2.py3-none-any.whl"
},
{
"comment_text": "",
"digests": {
"md5": "2747f35626ddd307ebb475ee25cdc463",
"sha256": "f0e82f8fb29557ddeb20136669f0ba06b3ed0cc26a2d8dbcd6ea973b7b6d870f"
},
"downloads": -1,
"filename": "bigquery-fdw-1.3.2.tar.gz",
"has_sig": false,
"md5_digest": "2747f35626ddd307ebb475ee25cdc463",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 8024,
"upload_time": "2018-05-11T16:05:05",
"url": "https://files.pythonhosted.org/packages/af/74/2e8b34ce3c082dc5b36df7b3ea987f32d15588c2f9f58fe19036d10c0d9c/bigquery-fdw-1.3.2.tar.gz"
}
],
"1.4": [
{
"comment_text": "",
"digests": {
"md5": "273733319267eab9b83695b9c3580785",
"sha256": "61c344b10124745c7cf91b159acac61f60621b26a55c4506faf7f870765a0b3e"
},
"downloads": -1,
"filename": "bigquery_fdw-1.4-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "273733319267eab9b83695b9c3580785",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 12436,
"upload_time": "2018-05-28T03:24:07",
"url": "https://files.pythonhosted.org/packages/b4/d2/4d81c95fc81aede4fcda0fe340fb74dee2536ce9d9d62796f2d7fc42f21f/bigquery_fdw-1.4-py2.py3-none-any.whl"
},
{
"comment_text": "",
"digests": {
"md5": "e245220bf92ea819d1f86f90913a6b18",
"sha256": "ab25d5caaff41bd020e36c9effb1f3db7390fb074c074c866e23ed0f14a32101"
},
"downloads": -1,
"filename": "bigquery-fdw-1.4.tar.gz",
"has_sig": false,
"md5_digest": "e245220bf92ea819d1f86f90913a6b18",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 9130,
"upload_time": "2018-05-28T03:24:09",
"url": "https://files.pythonhosted.org/packages/d4/52/019ab3017c19cd1739dd596101819ec6d400fc72cf660464a628da742c9e/bigquery-fdw-1.4.tar.gz"
}
],
"1.5": [
{
"comment_text": "",
"digests": {
"md5": "9056e602480a655b1adf00416c33a013",
"sha256": "2bb885816e6629687ad69e22c26ff89746135dd180a9cb24d82383ce1df396b0"
},
"downloads": -1,
"filename": "bigquery_fdw-1.5-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "9056e602480a655b1adf00416c33a013",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 9813,
"upload_time": "2018-06-19T21:03:59",
"url": "https://files.pythonhosted.org/packages/54/bd/39123a00a17117bc29b3e5d04bdf027aae76e3ccff61973aa2ea52aa4d7f/bigquery_fdw-1.5-py2.py3-none-any.whl"
},
{
"comment_text": "",
"digests": {
"md5": "73fe32cae2e890e48f9ab173c8a9ce69",
"sha256": "85fdba73a6e5d1252340c8e582d29a3f3869202bd52517192679d7be54ae656f"
},
"downloads": -1,
"filename": "bigquery-fdw-1.5.tar.gz",
"has_sig": false,
"md5_digest": "73fe32cae2e890e48f9ab173c8a9ce69",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 9258,
"upload_time": "2018-06-19T21:04:00",
"url": "https://files.pythonhosted.org/packages/ee/24/37b2b46fcfe9d98930c3f9bbc3d5ef5c79008271235094904b389794d9ac/bigquery-fdw-1.5.tar.gz"
}
]
},
"urls": [
{
"comment_text": "",
"digests": {
"md5": "9056e602480a655b1adf00416c33a013",
"sha256": "2bb885816e6629687ad69e22c26ff89746135dd180a9cb24d82383ce1df396b0"
},
"downloads": -1,
"filename": "bigquery_fdw-1.5-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "9056e602480a655b1adf00416c33a013",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 9813,
"upload_time": "2018-06-19T21:03:59",
"url": "https://files.pythonhosted.org/packages/54/bd/39123a00a17117bc29b3e5d04bdf027aae76e3ccff61973aa2ea52aa4d7f/bigquery_fdw-1.5-py2.py3-none-any.whl"
},
{
"comment_text": "",
"digests": {
"md5": "73fe32cae2e890e48f9ab173c8a9ce69",
"sha256": "85fdba73a6e5d1252340c8e582d29a3f3869202bd52517192679d7be54ae656f"
},
"downloads": -1,
"filename": "bigquery-fdw-1.5.tar.gz",
"has_sig": false,
"md5_digest": "73fe32cae2e890e48f9ab173c8a9ce69",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 9258,
"upload_time": "2018-06-19T21:04:00",
"url": "https://files.pythonhosted.org/packages/ee/24/37b2b46fcfe9d98930c3f9bbc3d5ef5c79008271235094904b389794d9ac/bigquery-fdw-1.5.tar.gz"
}
]
}