Discussions

Ask a Question

Cannot run query or view any records.

It keeps saying "Disconnected" on the query box.

Region for Bit.io data

Hi there, it is not clear from the docs, where bit.io data is stored. I am working on an application where privacy laws may become an issue, if so, does the paid version give the opportunity to change the region or is all data stored in the US?

GUI table editing

There was a way to manage tables through the UI. That was documented here - did that feature move? It was really nice to be able to edit tables without SQL. https://docs.bit.io/docs/schema-management
ANSWERED

DROP command not working

DROP TABLE IF EXISTS "alanparadise/nw"."shippers" - This is my SQL statement I am not able to find anything wrong here but it is showing as an unsupported operation. Any reason why this could be happening? I checked the help section of bit.io and the syntax seems to be the same so I'm not understanding what they exactly mean by unsupported operation here.

Connect to Excel - VBA

Hi, I'm tryying to connect my VBA project to a database. My VBA code has been already tested by using a local SQL database. Command I am using is: "Provider=MSDASQL;Driver={MySQL ODBC 8.0 Unicode Driver};Server=" & DB_ServerName & ":" & DB_Port & ";Database=" & DB_Name & ";user=" & DB_UserID & ";password=" & DB_PW & ";" Can you please halp me? Thanks in advance

Error: cross-database references are not implemented

I am getting the following error when trying to access table data after I am connected in Power BI DataSource.Error: ODBC: ERROR [0A000] ERROR: cross-database references are not implemented: Error while executing the query Details: DataSourceKind=Odbc DataSourcePath=dsn=PostgreSQL35W OdbcErrors=[Table]
ANSWERED

Report of the rows consulted by month

How can you know how many rows are being queried per month? What happens if the limit 10M rows queried is exceeded in Free or other mode? Thanks!

bit.io and Streamlit

In version 1 Streamlit and bitdotio have dependency conflicts that can not be resolved via pip. Any plans to resolve this in future deployments?
ANSWERED

Bio.io with Zapier

I'm new to bit.io. I just created a Zapier connection using PostgreSQL and the connection info provided by bio.io. Zapier reports that the connection was successful but I can't create a step because the connection shows no tables. (I have four tables in bit.io.) Any hints on what I need to do?
ANSWERED

Ways to Optimize Query Speed?

Is there a way to increase query speed on a large table? Maybe a way to create an index on a particular column or a way to increase processing resources?