Skip to main content

Rockset Python Client and `rock` CLI

Project description

This package includes the Rockset Python SDK that includes the following:

  • Native Python API to connect to Rockset, manage data and execute queries. This API includes Rockset’s query builder that allows for programmatic construction of advanced queries using native Python expressions.

  • rock command line utility to interact, manage and operate Rockset from a shell command line.

  • rock CLI does not include a SQL REPL command-line tool. Please install the rockset_sqlcli package to use that.

  • SQL connector for Python, which conforms to the Python DB API 2.0 specification. Refer to https://www.python.org/dev/peps/pep-0249 for more details.

  • SQLAlchemy dialect to bridge Rockset and SQLAlchemy applications. SQLAlchemy users can connect to Rockset using ‘rockset://<api_key>:@<api_server>’

Rockset documentation is available at: http://docs.rockset.com

Release Notes

  • 0.6.33-beta.20200131

    • add support for saved queries

  • 0.6.32-beta.20200116

    • fix query builder to support workspaces correctly

  • 0.6.24-beta.20191202

    • map Rockset DATE, TIME, DATETIME, TIMESTAMP and MICROSECOND INTERVAL data types to Python’s corresponding datetime types.

    • add patch_docs() API to collections to update any documents in a collection atomically without having to reingest the entire document.

    • improved SQLAlchemy support

    • improved support for Apache Superset

  • 0.6.17-beta.20191026

    • fix bug: do not automatically check for updates in rockset.version()

  • 0.6.16-beta.20191013

    • moved rock sql interactive REPL to a new Python package rockset_sqlcli

  • 0.6.0-beta.20190617

    • move from cloud-level integrations to service-level integrations: DynamoDB, GCS, Kinesis, Redshift, S3

  • 0.5.33-beta.20190530

    • fixed Windows environment issue

  • 0.5.30-beta.20190517

    • add support for AWS Redshift

    • rock upload supports uploading multiple files

  • 0.5.23-beta.20190225

    • rock ls shows creation time and size of collection

    • Better error handling

    • Add support for Workspaces

  • 0.5.15-beta.20190124

    • Update User-Agent value passed in API request header

  • 0.5.14-beta.20190121

    • Add support for Google Cloud Storage

  • 0.5.13-beta.20190117

    • SQLAlchemy enhancements to support Apache Superset

  • 0.5.10-beta.20190114

    • Added support for AWS External ID as a new type of integration.

    • Added support for prefix and pattern as parameters under rs.Source.s3()

    • Deprecated rs.Source.s3(…prefixes=[…]). This is still supported but it’s recommended that you move to using prefix as soon as possible.

    • Fixed bug in rock upload to use current working directory.

  • 0.5.9-beta.20190104

    • Add support for Amazon DynamoDB data source

    • Replace rock add with rock upload

  • 0.5.6-beta.20181210

    • Support for creating collections from XML data files

  • 0.5.0-beta.20181107

    • First beta release

    • Add support for kinesis data source

    • Better error messages when an account reaches resource limit

    • REST API over swagger_client instead of bravado

  • 0.4.3-alpha.20181003-3eaa5c7cc7

    • Support for field masks.

    • Support for slow rollout of leaves based on healthz checks

  • 0.4.3-alpha.20180916+57afbae46a

    • Support for creating collections from csv data files

  • 0.4.2-alpha.20180910+cf9c623a49

    • Support for creating collections using integrations

    • Improved help text for rock create workflows

  • 0.4.1-alpha.20180822+e806a29bab

    • Support for event time data and data retention during collection creation.

    • Changes to rock create collection … commandline to improve readability

    • rock drop … is now rock drop collection …

    • rock describe … is now rock describe collection …

  • 0.4.0-alpha.20180515+ecbe2a0

    • Moved to new /org/{org} REST API

    • Add SQL support that is accessible from rock sql

    • Field _id defines the unique identified for a document (:id deprecated)

    • Field _meta captures all other system generated fields in documents (:collection etc deprecated)

  • 0.3.0-alpha.20180314+410b55e

    • Add py query builder support for <, <=, > and >= operators for string values

  • v0.3.0-alpha.20180206+168be7d

    • Add F.collect() support to accumulate entire parent documents as part of a bucket aggregation

  • v0.3.0-alpha.20171206+7debcb7

    • Add collect aggregate function to support bucket aggregations

    • Add support for F.count() to do equivalent of count(*)

  • v0.3.0-alpha.20171121+d8c7961

    • Sensitive fields can now be masked or anonymized, when collections are created from AWS S3. See rock help create collection for more details.

    • AWS S3 bucket path prefixes can be provided to create a collection from only a subset of data in an AWS S3 bucket.

    • Support Parquet file format for loading data into collections.

  • v0.3.0-alpha.20170919+49e62f5

    • Simpler REST API 0.3

    • Add fence API and write APIs returning commit markers

    • Add View creation progress indicator to describe view API

    • More user-friendly error messages and Python exception strings

    • Enforce and document various system-wide limits

  • v0.2.2-alpha.20170824+dff8385

    • Support for next version of api_key and got rid of api_secrets

    • Added support for adding multiple documents in single API call

    • Added rockset.source to better support managing S3 sources while creating collections and collection sources while creating views.

    • Better client support for views with multiple analyzer mappings

    • py/client supports async_requests to have multiple concurrent queries pending

    • Support for sampling queries and queries on nested documents

    • Backend: better query optimization support

  • v0.2.1-alpha.20170707+88ab952

    • Added support for views

  • v0.2.1-alpha.20170629+4492c9a

    • py/client now respects HTTP_PROXY and HTTPS_PROXY ENV variables

  • v0.2.1-alpha.20170629+7b050f5

    • Fix bug that made limit queries not composable

  • v0.2.1-alpha.20170628+303f256

    • Added cursors with automatic pagination support

    • Added support for limit & skip queries

  • v0.2.1-alpha.20170624+e6aee25

    • Added support for lookup operator for JOINs

    • Auth token auto refresh will support long lived Client() objects

  • v0.2.1-alpha.20170615+f3df06e

    • Parallel aggregations for faster performance

    • Aggregation support for nested fields

    • Aggregation support over large data sets

    • Rewrote backend service discovery to make it elastic

    • User friendly messages for all py/client exceptions

  • v0.1.1-alpha

    • First alpha release

Release history Release notifications | RSS feed

Download files

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

Source Distribution

rockset-0.6.33b20200131.tar.gz (144.2 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

rockset-0.6.33b20200131-py3-none-any.whl (307.9 kB view details)

Uploaded Python 3

File details

Details for the file rockset-0.6.33b20200131.tar.gz.

File metadata

  • Download URL: rockset-0.6.33b20200131.tar.gz
  • Upload date:
  • Size: 144.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.1.1 pkginfo/1.5.0.1 requests/2.22.0 setuptools/45.1.0 requests-toolbelt/0.9.1 tqdm/4.42.0 CPython/3.6.9

File hashes

Hashes for rockset-0.6.33b20200131.tar.gz
Algorithm Hash digest
SHA256 77d13b60305bae21e91dfc32e23921cc0fbf663b2c0b4e3a27a6d57a4fc566cb
MD5 369d43204247e8f56e0d6eac39765ad5
BLAKE2b-256 beff4b9c822facf54b89cdc13473e506640917ea7b52af665a5b2573989e764c

See more details on using hashes here.

File details

Details for the file rockset-0.6.33b20200131-py3-none-any.whl.

File metadata

  • Download URL: rockset-0.6.33b20200131-py3-none-any.whl
  • Upload date:
  • Size: 307.9 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.1.1 pkginfo/1.5.0.1 requests/2.22.0 setuptools/45.1.0 requests-toolbelt/0.9.1 tqdm/4.42.0 CPython/3.6.9

File hashes

Hashes for rockset-0.6.33b20200131-py3-none-any.whl
Algorithm Hash digest
SHA256 e4461d3d8bd846f30b05d51c3007c90056f89008a0d8c494ae3eb3fdab3c3399
MD5 15f9ef3d42ee34cd235f7b52a6772385
BLAKE2b-256 ebbfbe6bc678030162e7c40150534bd17df8522239b8d0833a7142e84b755881

See more details on using hashes here.

Supported by

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