Parquet schema
Hackolade dynamically generates Parquet schema for the structure created with the application.
The script can also be exported to the file system via the menu Tools > Forward-Engineering, or via the Command-Line Interface.
Documentation
Table of contents
- Welcome to Hackolade Studio
- Vision
- Getting started
- Tutorial
- What is a data model?
- Overview of JSON and JSON Schema
- Query-driven data modeling based on access patterns
- Create your first data model
- Add nested objects and arrays
- Add a choice, conditional, or pattern field
- Add relationships
- Import or reverse-engineer
- Export or forward-engineer
- Generate documentation and pictures
- Create model for graph databases
- Create a REST API model
- Leverage a Polyglot data model
- Pragmatic guide to a data modeling strategy
- Conceptual modeling with Polyglot
- Logical modeling with Polyglot
- Embedding nested objects within parent entities
- Referencing separate entities with foreign key relationships
- Extended referencing hybrid with selective duplication
- Derive from polyglot vs external reference
- Design a hierarchical schema from a normalized Polyglot model
- Convert model into a Polyglot in another repository
- How to organize models
- How-to guides
- Define composite key constraints
- Configure custom properties
- Integrate the CLI with DevOps CI/CD pipelines
- Add reusable definitions
- Naming Conventions use cases
- Technical names in Polyglot models
- Model compare and merge use cases
- Recreate broken reference link to a Polyglot model
- Pre-populate new entities using snippets
- Pre-populate properties with default values
- Inheritance in Polyglot models
- Best practices for collaboration and change management
- Oracle 23ai and 26ai Duality Views
- Union types in Avro
- Hackolade Model Hub
- Overview
- Model Hub solution architecture
- Model Hub technical architecture
- Browser configuration
- Model Hub user interface
- Model Hub FAQs
- Model Hub deployment
- Data modeling and the AI lifecycle
- SQL and NoSQL databases, APIs, and storage formats
- Polyglot Data Model
- JSON Schema
- Couchbase
- DynamoDB
- MongoDB
- Download additional target plugins
- Avro schema
- BigQuery
- Cassandra
- CockroachDB
- Confluent Schema Registry
- Cosmos DB SQL & MongoDB APIs
- Cosmos DB Gremlin
- Couchbase with scopes and collections
- Db2
- Delta Lake on Databricks
- DocumentDB
- Elasticsearch
- EventBridge
- Event Hubs Azure Schema Registry
- Firebase
- Firestore
- Glue Data Catalog
- GraphQL
- HBase
- Hive
- JanusGraph
- MariaDB
- MarkLogic
- MySQL
- Neo4j
- Neptune Gremlin
- OpenAPI
- Oracle
- Parquet schema
- PostgreSQL
- Protobuf
- Pulsar Schema Registry
- Redshift
- ScyllaDB
- Snowflake
- SQL Server
- Swagger API
- Synapse
- Teradata
- TinkerPop
- YugabyteDB
- Concepts
- Schema design in a schemaless world
- Benefits of data modeling apply to NoSQL and Agile
- ER diagrams and cardinality
- JSON Schema Tree view
- Attributes
- Relationships and denormalization
- Polyglot Data Modeling
- Inheritance strategies
- Model a supertype group in Polyglot
- Materialize a supertype group when deriving from Polyglot
- Derive a Polyglot model with supertype groups
- Derive with Preserved hierarchy
- Derive with Roll-up flat strategy with discriminator
- Derive with Roll-up nested strategy
- Derive with Roll-down strategy
- Mixed strategies inside supertype group
- Hierarchy of multiple levels
- One supertype with multiple groups
- Inheritance created before version v8.13.0
- Schema versioning
- Team collaboration
- Model versioning
- Data modeling techniques
- Overview of user interface
- Welcome page
- Workspace
- JSON Schema Editor
- Manipulating shapes
- Show model diff
- Compare and merge models
- Delta model and ALTER script
- Generate documentation
- Print a diagram
- Shortcut keys
- Re-usable objects definitions
- User-defined custom properties
- Command Line Interface
- Naming conventions
- Glossaries of business terms
- AI-assisted data modeling
- Lineage capture
- Suggest denormalization of a SQL schema
- Infer Primary Keys and Foreign Key Relationships
- Model-Driven API Generation
- Generate mock data for testing
- Verify Data Model
- Governance Platforms Integration
- Bizzdesign EA integration
- MongoDB Field-Level Encryption
- Repository
- Concepts
- Authentication
- Connect to a repository hub
- Share model link URL
- Working directly with a remote repo
- Working with a locally-cloned repo
- Pre-requisites
- Clone a remote repository
- Open a local repository
- Explore repository
- Checkout a branch
- Commit local changes
- Pull remote commits
- Push local commits
- Solve conflicts
- Submit for review
- Review change requests
- Branch protection
- Working with forks
- Git subtree
- Other actions
- Questions & Answers
- Quick start guide
- Create a new model from scratch
- Forward-Engineering
- JSON Document
- YAML file
- JSON Schema
- YAML Schema
- Excel file
- API Model
- dbt artifacts
- ArchiMate application data objects
- Target-specific
- Avro schema
- BigQuery DDL
- Cassandra CQL
- CockroachDB DDL
- Cosmos DB SQL API scripts
- Cosmos DB Gremlin script
- Couchbase scripts
- Db2 DDL
- Delta Lake scripts
- DocumentDB script
- DynamoDB scripts
- Elasticsearch mappings
- EventBridge
- Ottoman Schema
- Firebase (TBA)
- Firestore (TBA)
- Glue Data Catalog
- HBase
- Hive HQL
- JanusGraph Gremlin
- MariaDB DDL
- MarkLogic
- MongoDB scripts
- Mongoose Schema
- MySQL DDL
- Neo4j Cypher
- Neptune with Gremlin API
- OpenAPI file
- Oracle DDL
- Parquet schema
- PostgreSQL DDL
- Protobuf schema
- Redshift DDL
- ScyllaDB CQL
- Snowflake DDL
- SQL Server DDL
- Synapse DDL
- Swagger file
- Teradata DDL
- TinkerPop Gremlin
- Forward-Engineering
- Reverse-engineering
- JSON document
- YAML file
- JSON Schema
- YAML Schema
- SQL DDL
- Diagrams
- Excel template
- PowerDesigner
- MEGA Hopex
- XSD (XML Schema Definition)
- MongoDB Relational Migrator
- Target-specific
- Avro file or schema
- Connect to a BigQuery instance
- Connect to a Cassandra instance
- Connect to a CockroachDB instance
- Connect to Confluent Schema Registry
- Connect to a Cosmos DB instance
- Connect to a Couchbase instance
- Connect to a Db2 instance
- Connect to a Delta Lake instance
- Connect to a DocumentDB instance
- Connect to a DynamoDB instance
- Connect to an Elasticsearch instance
- Connect to EventBridge Schema Registry
- Connect to a Firebase instance (TBA)
- Connect to a Firestore instance (TBA)
- Connect to an AWS Glue Data Catalog
- Connect to an HBase instance
- Connect to a Hive instance
- Connect to a JanusGraph instance
- Connect to a MariaDB instance
- Connect to a MarkLogic instance
- Connect to a MongoDB instance
- Connect to a MySQL instance
- Connect to a Neo4j instance
- Connect to a Neptune instance
- OpenAPI file
- Connect to an Oracle instance
- Parquet schema
- Connect to a PostgreSQL instance
- Protobuf schema file or registry
- Connect to Amazon Redshift
- Connect to a ScyllaDB instance
- Connect to a Snowflake instance
- Connect to a SQL Server instance
- Connect to Synapse
- Swagger file
- Connect to a Teradata instance
- Connect to a TinkerPop instance
- Connect to YugabyteDB
- Create a new model from scratch
- FAQ and troubleshooting
- More FAQs
- Glossary
On this page