Faker
Setting up the Faker connector
| No | Item | Required | Example | Notes |
|---|---|---|---|---|
| 1 | Count | Yes | How many users should be generated in total. This setting does not apply to the purchases or products stream. | |
| 2 | Seed | No | Manually control the faker random seed to return the same values on subsequent runs (leave -1 for random) | |
| 3 | Records Per Sync | No | How many fake records will be returned for each sync, for each stream? By default, it will take 2 syncs to create the requested 1000 records. | |
| 4 | Records Per Stream Slice | No | How many fake records will be in each page (stream slice), before a state message is emitted? | |
| 5 | Parallelism | No | How many parallel workers should we use to generate fake data? Choose a value equal to the number of CPUs you will allocate to this source. |
Tables in the Faker connector
| No | Table Name | Columns | Primary Keys | Read Mode | Inc. Sync Keys | API Info |
|---|---|---|---|---|---|---|
| 1 | purchases | 6 | Incremental, Full Refresh | created_at | ||
| 2 | users | 16 | Incremental, Full Refresh | created_at | ||
| 3 | products | 6 | Incremental | created_at |
Table: purchases
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | purchased_at | VARCHAR | |
| 2 | user_id | DOUBLE | |
| 3 | returned_at | VARCHAR | |
| 4 | product_id | DOUBLE | |
| 5 | id | DOUBLE | |
| 6 | added_to_cart_at | VARCHAR |
Table: users
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | occupation | VARCHAR | |
| 2 | gender | VARCHAR | |
| 3 | academic_degree | VARCHAR | |
| 4 | created_at | VARCHAR | Incremental sync key |
| 5 | weight | INTEGER | |
| 6 | telephone | VARCHAR | |
| 7 | language | VARCHAR | |
| 8 | title | VARCHAR | |
| 9 | updated_at | VARCHAR | |
| 10 | nationality | VARCHAR | |
| 11 | blood_type | VARCHAR | |
| 12 | name | VARCHAR | |
| 13 | id | DOUBLE | |
| 14 | age | INTEGER | |
| 15 | email | VARCHAR | |
| 16 | height | VARCHAR |
Table: products
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | year | DOUBLE | |
| 2 | price | DOUBLE | |
| 3 | created_at | VARCHAR | Incremental sync key |
| 4 | model | VARCHAR | |
| 5 | id | DOUBLE | |
| 6 | make | VARCHAR |
External Resources
Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.