topic intermittent connection error in Data Engineering https://community.databricks.com/t5/data-engineering/intermittent-connection-error/m-p/12180#M7034 <P>I am running dbsqlcli in windows 10. I have put together the attached cmd file to pull the identity column data from a series of our tables into individual CSVs so I can upload then to a PostgreSQL DB to do a comparison of each table to those in the PG DB.</P><P></P><P>In the attached output log file you can see that some of the commands result in an error and written into the output CSV file is:</P><P>There was an error while connecting to Databricks SQL. It could be caused due to missing/incomplete configuration. Please verify the configuration in ~/.dbsqlcli/dbsqlclirc and run dbsqlcli again.</P><P>For more details about the error</P><P></P><P>Why would this happen so apparently inconsistently? I tried adding a DOS wait of 5 sec between each dbsqlcli to try to overcome what I thought was threads not closing completely in between. It does not help.</P><P></P><P>Are there parameters or qualifiers which I can set to prevent this?</P><P>Any other suggestions would be appreciated.</P> Wed, 27 Jul 2022 16:46:52 GMT Herkimer 2022-07-27T16:46:52Z intermittent connection error https://community.databricks.com/t5/data-engineering/intermittent-connection-error/m-p/12180#M7034 <P>I am running dbsqlcli in windows 10. I have put together the attached cmd file to pull the identity column data from a series of our tables into individual CSVs so I can upload then to a PostgreSQL DB to do a comparison of each table to those in the PG DB.</P><P></P><P>In the attached output log file you can see that some of the commands result in an error and written into the output CSV file is:</P><P>There was an error while connecting to Databricks SQL. It could be caused due to missing/incomplete configuration. Please verify the configuration in ~/.dbsqlcli/dbsqlclirc and run dbsqlcli again.</P><P>For more details about the error</P><P></P><P>Why would this happen so apparently inconsistently? I tried adding a DOS wait of 5 sec between each dbsqlcli to try to overcome what I thought was threads not closing completely in between. It does not help.</P><P></P><P>Are there parameters or qualifiers which I can set to prevent this?</P><P>Any other suggestions would be appreciated.</P> Wed, 27 Jul 2022 16:46:52 GMT https://community.databricks.com/t5/data-engineering/intermittent-connection-error/m-p/12180#M7034 Herkimer 2022-07-27T16:46:52Z