CrateDB SQLAlchemy dialect – all pages¶ Table of contents Getting started Introduction Connect Basic DDL operations CRUD Operations Introduction Create Retrieve Update Delete Data Types Introduction Introduction to container types ObjectType ObjectArray Geospatial types Vector type Advanced querying Introduction Introduction to fulltext indexes Fulltext search with MATCH predicate Aggregates: Counting and grouping INSERT...FROM SELECT INSERT...RETURNING Inspection and Reflection Introduction Inspector Schema-supported reflection CrateDialect DataFrame operations About Introduction Compatibility notes Efficient INSERT operations with pandas Efficient INSERT operations with Dask Support Features Bulk Support for pandas and Dask Context Manager table_kwargs Synthetic Autoincrement using Timestamps Synthetic Table REFRESH after DML Synthetic UNIQUE Constraints