Airbyte connectors
Faker

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:


_51
CREATE 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
_51
CREATE 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
_51
CREATE 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

FeatureSupportedNotes
Full Refresh SyncYes
Incremental SyncNo
NamespacesNo

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 MarketingFile import