How does data connection work as far as keeping connections alive? Temp tables persist in HANA so long as the session is active, they get automatically deleted when you disconnect. When does data connection disconnect you from a table, if at all?
Hi @raj,
This is an implementation detail of the data connection sync/export and should not be relied upon while designing your data pipeline.
Generally, a sync/extract will maintain a session/connection throughout its duration. However, if a job opens multiple connections to perform parallel uploads/downloads or if it loses a connection and attempts to reconnect, this may not hold true.
Could you share details of what you’re trying to achieve and what source type/capability you’re using?
Thanks Jivitesh! The main goal to understand is that we have a connection to HANA, where if we have a Temp table available we can connect to it and ingest it. That said, my understanding is if we stop connecting to that table it goes inactive and the table will disappear. My question is essentially how the data connection works in this case so we know how long the Temp table will persist