Frequently Asked Questions

A list of typical questions that you may have. If you don't find a solution here, don't hesitate to contact us.

Last updated 1 year ago

Was this helpful?

Frequently Asked Questions

A list of typical questions that you may have. If you don't find a solution here, don't hesitate to contact us.

What is the pricing of your Connectors?

After a Free 7-day Trial, we will only charge:

$0.10 per refresh
$5 / per million rows ingested

As an example, let's say that you set up a scheduled task during the working days at 7:00 a.m. for your , and that during each refresh you ingest 2000 rows (only new and updated rows, thanks to our incremental ingestion). In that case, you would only pay $0.55 per week!

Besides that, our applications are built in the Native Snowflake Apps, and, since they run on your own Snowflake instance you will be charged by Snowflake for the warehouse compute cost.

How do I upload data into preexisting databases and schemas?

Configuring a connection to save data on preexisting databases or schemas will throw an error if the privileges were not properly granted to the application.

Solution

Execute the following commands

-- For preexisting databases
grant usage on database <db_to_use> to application <application_name>;
grant create schema on database <db_to_use> to application <application_name>;

-- For preexisting databases and schemas
grant usage on schema <db_to_use>.<schema_to_use> to application <application_name>;
grant create table on schema <db_to_use>.<schema_to_use> to application <application_name>;

These commands will grant the application permission to see, use and create new tables on preexisting databases and schemas.

What happens if I set up wrong credentials or my task ingestion fails?

We will only charge for data that has actually been fetched and correctly ingested in your account. If all calls to the API return errors, then there will be no cost for that run.

If you have made a mistake with your credentials, simply delete the connection and create a new one with the correct credentials. Make sure to test the connection before setting up the scheduled task and your data will be ready in no time!

Incremental Ingestion vs. Incremental Fetching

Incremental Ingestion: All our connectors have an incremental ingestion strategy implemented. When data is fetched from an API (Personio, Active Campaign, Hubspot...) we check the last time it was updated and compare it with the previously saved data in your Snowflake account. If the data in your account is already up to date, we discard the fetched data and you are not charged for it. Not all endpoints provide the information necessary for this check and, in those cases, we ingest the data.
Incremental Fetching: Some APIs allow to fetch data given some date and time parameters. In those cases we can fetch only the updated data from the APIs, making the data ingestion process much faster and cheaper. The amount you will be charged is the same as in the Incremental Ingestion process, but it still be much cheaper because the time that the warehouses are running can be much shorter. Not all APIs provide the information necessary for this method and, in those cases, the Incremental Ingestion strategy applies.

Last updated 1 year ago

Was this helpful?

What is the pricing of your Connectors?

After a Free 7-day Trial, we will only charge:

$0.10 per refresh
$5 / per million rows ingested

Besides that, our applications are built in the Native Snowflake Apps, and, since they run on your own Snowflake instance you will be charged by Snowflake for the warehouse compute cost.

How do I upload data into preexisting databases and schemas?

Configuring a connection to save data on preexisting databases or schemas will throw an error if the privileges were not properly granted to the application.

Solution

Execute the following commands

-- For preexisting databases
grant usage on database <db_to_use> to application <application_name>;
grant create schema on database <db_to_use> to application <application_name>;

-- For preexisting databases and schemas
grant usage on schema <db_to_use>.<schema_to_use> to application <application_name>;
grant create table on schema <db_to_use>.<schema_to_use> to application <application_name>;

These commands will grant the application permission to see, use and create new tables on preexisting databases and schemas.

What happens if I set up wrong credentials or my task ingestion fails?

We will only charge for data that has actually been fetched and correctly ingested in your account. If all calls to the API return errors, then there will be no cost for that run.

Incremental Ingestion vs. Incremental Fetching

Incremental Ingestion: All our connectors have an incremental ingestion strategy implemented. When data is fetched from an API (Personio, Active Campaign, Hubspot...) we check the last time it was updated and compare it with the previously saved data in your Snowflake account. If the data in your account is already up to date, we discard the fetched data and you are not charged for it. Not all endpoints provide the information necessary for this check and, in those cases, we ingest the data.
Incremental Fetching: Some APIs allow to fetch data given some date and time parameters. In those cases we can fetch only the updated data from the APIs, making the data ingestion process much faster and cheaper. The amount you will be charged is the same as in the Incremental Ingestion process, but it still be much cheaper because the time that the warehouses are running can be much shorter. Not all APIs provide the information necessary for this method and, in those cases, the Incremental Ingestion strategy applies.