Is there a way to disable this showing up? I’d rather have the spinner without the peak into the code that is running, but removing it entirely also works. Happy to run some CSS/HTML hackiness to remove it, just need to know where it is.
There is a show_spinner argument to SQLConnection.query. But your spinner seems to come from somewhere else. I mean, that is not the default message so some code (either your own or someone else’s) is already changing it.
Is there an advantage to switching to Streamlit’s native SQLConnection.query method?
def __get_connection(self):
"""
Connects to Snowflake; use in a with statement to ensure connection closes.
"""
self.__connection = snowflake.connector.connect(
user=self.user,
password=self.password,
account=self.account,
database=self.database,
warehouse=self.warehouse,
)
return self.__connection
I was answering according to the context in the linked post, because that was pretty much the only context I had. I know nothing about snowflake, but I don’t think you can use SQLConnection to access it.
Apparently you are calling MarketInsightsDataQuery.get_latest_contract_date_electricity_futures_settlement_prices(), but I have no idea what that is or how you are calling it.
It is simply a class method that sets up the snowflake connection and then queries data. The query method is simply called in the page to return a pandas dataframe.
