Example of using SQLAlchemy+Pandas, works with this Cloud SQL as well

from sqlalchemy import create_engine
import pandas as pd

server = '<your-server-hostname>'
port = 1972
namespace = 'USER'
username = 'SQLAdmin'
password = '<YOUR_PASSWORD>'

url = f"iris://{username}:{password}@{server}:{port}/{namespace}"
print(url)
engine = create_engine(url)

df = pd.DataFrame({
    'int': [1, 2, 3, 4, 5],
    'float': [1.1, 2.2, 3.3, 4.4, 5.5],
    'string': ['a', 'b', 'c', 'd', 'e'],
    'datetime': pd.date_range('20130101', periods=5),
    'bool': [True, False, True, False, True]
})

# create a table in IRIS
df.to_sql('iris_table', engine, if_exists='replace', schema='sqlalchemy')

# read the table back from IRIS 
df2 =  pd.read_sql_table('iris_table', engine, schema='sqlalchemy')
# print the dataframe
print(df2)

Squirrel actually already has a driver definition for Caché and IRIS out of the box
And DBeaver has this ability too

Could you update the article and extract the tutorial out of pdf?
 

Yeah, the VSCode plugin has not been updated for a while. The ObjectScriptQuality plugin itself already has new ARM64 support. We'll check and update the extension soon.

Have a look at some of my projects which can help with this contest

• irissqlcli - REPL for IRIS SQL
• sqlalchemy-iris dialect for SQLAlchemy, can be used with Pandas, Flask or FastAPI
• django-iris driver for Django
• dbt-iris adapter for dbt

Give it a try and let me know if you have any issues with them, I can help to solve

Well, it’s not so old, it is definitely supports SourceControl class

How old is that Cache there?

Sorry, but it is the most horrible way to do it.

too old-school, the code has been outdated for many years. Dots syntax in 2023, seriously?

Projections are definitely not a way to solve it and did not get why they were even considered here

The best way to go is using %Studio.SourceControl, there are a lot of examples, and even some are out of the box already.

And most modern way now is to switch from Studio to VSCode, and to local-side development. So, all your classes will always be as files and can be synced to the git repository.

I’m not a fun of using LOAD DATA, it’s not complete, there are some things required to be kept in mind.

now I would recommend to look at dbt tool, which has support for IRIS, and may probably support older versions too, and it works with CSV quite easy, and can create table for you as well. Have a look, and let me know if you have any issues with it. I can fix bugs in IRIS support, if you find any. For IRIS you would need use dbt-iris package 

I have tool for it, but it requires full authorization 

https://github.com/caretdev/iscctl

Not sure why you think, that the IP is wrong. And probably it's the Windows thing and WSL

But, I use this way a lot of time, when I need to access from some docker container, some another service running locally, or another docker container not connected to the same network, and it works fine. This address is supposed to be used only from the container, it should not show the real IP address of the host. If you wish to show some URL, which will be available outside of the container, obviously it will not help.

Great, thanks for the post. I still did not manage to do it by myself.