Discussions

Ask a Question

pricing schema

Hi I am not sure I fully understand the pricing, could you help me? For example if I query "select * from table limit 100" I will "pay" for 100 rows read. If I alter a table, let's say I add a column, how many rows i would read? The entire table? And if i write a new row? I would use 0 rows read, right?
ANSWERED

ERROR:root:(psycopg2.OperationalError) SSL connection has been closed unexpectedly

I can't ever do any writes. I keep getting this error. What am I doing wrong?
ANSWERED

COPY FROM DOCUMENTATION

In the documentation, the only info re: COPY FROM in psql is: ``` Through a Client Once you connect a database client to bit.io, you can upload data by making a SQL "INSERT INTO" or "COPY FROM" query. ``` I've tried multiple attempts always with the same error: command: `COPY table_name FROM '/path-to-csv/file.csv';` error: ``` ERROR: COPY to/from a filename is not supported DETAIL: Visit docs.bit.io for more detail how to COPY HINT: Use STDIN or STDOUT instead ``` Please could you tell me what I'm doing wrong and/or add more details to the documentation. Thanks
ANSWERED

Overwrite table option when importing

Hi there, Firstly, love the simplicity of bit.io, great UX for getting started. One thing that would be nice is to have an overwrite option when uploading data. I.e. it runs DELETE FROM <Table name> before importing the data.
ANSWERED

Connection issue

I'm trying to connect to bit.io from the Postico client on my Mac OSX desktop. I'm getting the following error when trying to connect to any of my dbs that already exist on bit.io. FATAL: configured character encoding scheme is not supported DETAIL: visit docs.bit.io for more detail HINT: try using a supported character encoding scheme SSL connection has been closed unexpectedly
ANSWERED

Assign grants

I can create a schema, but CREATE SCHEMA eth: I can´t assign grants to it: GRANT ALL ON SCHEMA eth TO postgres; Query failed: Feature Not Supported

Hi airbyte connection with api not working

Hi I tried a integration with airbyte , in the normalization part is always failing, I guess the problem is related with the permission in the user. I tried with a custom api source and with the poke api in airbyte and in both failed.

feature request: IP address whitelist

The endpoints are currently exposed to the internet. However, as this is undesirable from a security point of view, we would like the ability to block access from sources other than the authorised connection source. I would appreciate your consideration.

Different kinds of public databases/schemas

I can't quite figure out what the differences are in the following kinds of public databases, are there different kinds of public databases? How do I select the schema to upload my data onto as shown in [this](https://docs.bit.io/docs#upload-your-first-data-file) the tutorial? ## [Public Database 1](https://bit.io/bitdotio/census-surnames) - In contrast to the Public Database 2 below, each of the tables is listed under the `public` schema. - How do I reference the tables here from the query editor of my personal test database? ## [Public Database 2](https://bit.io/alanparadise/nw) - Seems like this kind of public database has another nested schema in the database. - Top left shows `alanparadise/nw` as the database, but in the list of tables on the left sidebar, all of them are listed under `alanparadise/nw` again. - Does this mean reference to the `orders` table would be `"alanparadise/nw"."alanparadise/nw"."orders"` when I'm trying referencing from the query editor of my personal test database? Thanks,
ANSWERED

Database password changes frequantly

Hi I have a problem with the database password changing too frequently. I cannot update my c# project every time that this password changes. Please help.