Faker for Snowflake in Java. Generates fake data natively on Snowflake.

Uses java-faker by DiUS: https://github.com/DiUS/java-faker

This repo is a sequel to the flaker repo. With flaker, faker runs in python on AWS API Gateway and is invoked as an External Function on Snowflake.

In this repo, we create a Java UDF which runs entirely within the Snowflake warehouse. Much easier to deploy!

Use your favourite Git client to clone this repository on your locale machine.

See https://docs.snowflake.com/en/user-guide/snowsql-install-config.html

snowsql -q "put 'file://target/*.jar' @~; put 'file://target/dependency/*.jar' @~"

snowsql -f fake.sql

snowsql -q "select fake('en_US','#{Name.FullName}') as FULL_NAME from table(generator(rowcount => 10));"

snowsql -q "select fake('ja_JP','#{Address.StreetAddress}') as STREET_ADDRESS from table(generator(rowcount => 10));"

Here's all the things you can generate:

http://dius.github.io/java-faker/apidocs/index.html

I committed the dependencies to this repo to avoid the hassle of doing this. But if you prefer, here's how you can do it from scratch.

On Linux/WSL:

sudo apt install default-jre-headless

On Linux/WSL:

sudo apt install maven

mvn install dependency:copy-dependencies