Faker

Overview

This page contains the setup guide and reference information for the Faker library source. The Sample Data (Faker) source fabricates sample data employing the Python mimesis (opens in a new tab) package.

Output schema

This source creates an eCommerce-like dataset featuring users, products, and purchases. When linked to a Postgres destination, the source will produce the following:


_51CREATE TABLE "public"."users" (
_51    "id" float8,
_51    "age" int8,
_51    "name" text,
_51    "email" text,
_51    "title" text,
_51    "gender" text,
_51    "height" text,
_51    "weight" int8,
_51    "language" text,
_51    "telephone" text,
_51    "blood_type" text,
_51    "created_at" timestamptz,
_51    "occupation" text,
_51    "updated_at" timestamptz,
_51    "nationality" text,
_51    "academic_degree" text,
_51    -- "_airbyte_ab_id" varchar,
_51    -- "_airbyte_emitted_at" timestamptz,
_51    -- "_airbyte_normalized_at" timestamptz,
_51    -- "_airbyte_dev_users_hashid" text,
_51    -- "_airbyte_unique_key" text
_51);
_51
_51CREATE TABLE "public"."products" (
_51    "id" float8,
_51    "make" text,
_51    "year" float8,
_51    "model" text,
_51    "price" float8,
_51    "created_at" timestamptz,
_51    -- "_airbyte_ab_id" varchar,
_51    -- "_airbyte_emitted_at" timestamptz,
_51    -- "_airbyte_normalized_at" timestamptz,
_51    -- "_airbyte_dev_products_hashid" text,
_51    -- "_airbyte_unique_key" text
_51);
_51
_51CREATE TABLE "public"."purchases" (
_51    "id" float8,
_51    "user_id" float8,
_51    "product_id" float8,
_51    "returned_at" timestamptz,
_51    "purchased_at" timestamptz,
_51    "added_to_cart_at" timestamptz,
_51    -- "_airbyte_ab_id" varchar,
_51    -- "_airbyte_emitted_at" timestamptz,
_51    -- "_airbyte_normalized_at" timestamptz,
_51    -- "_airbyte_dev_purchases_hashid" text,
_51    -- "_airbyte_unique_key" text
_51);

Features

Feature	Supported	Notes
Full Refresh Sync	Yes
Incremental Sync	No
Namespaces	No

An integer seed can be specified as an option for this connector. This ensures that the same fake records are produced each time. Otherwise, random data will be generated during each subsequent synchronization.

Requirements

None!

Facebook Marketing File import