If you need to export the result of SQL to CSV you can use csvgen lib. 

install csvgen:

USER>zpm "install csvgen"

Perform export:

USER>set query="select * from your.classname"

USER>w ##class(community.csvgen).SQLToCSV(";",1,"/folder/file.csv",query)

1

Nice! Stolen for one-liners)

Even better! Thanks @Sergey Mikhailenko 

And images with ZPM package manager 0.3.2 are available accordingly.

From clause could look like:

FROM intersystemsdc/iris-community:2022.1.0.114.0-zpm

And change the image to any of the following:

intersystemsdc/iris-community:2022.1.0.114.0-zpm
intersystemsdc/irishealth-community:2022.1.0.114.0-zpm
intersystemsdc/irishealth-ml-community:2022.1.0.114.0-zpm 
intersystemsdc/irishealth-community:2022.1.0.114.0-zpm
intersystemsdc/iris-community:2021.2.0.651.0-zpm
intersystemsdc/iris-ml-community:2021.2.0.651.0-zpm
intersystemsdc/irishealth-community:2021.2.0.651.0-zpm 
intersystemsdc/irishealth-ml-community:2021.2.0.651.0-zpm  

Also you can benefit from the latest and preview tags. Latest is equal to the latest GA IRIS, and preview is for the latest Preview version. e.g.

FROM intersystemsdc/iris-community:2021.2.0.651.0-zpm

equals to:

FROM intersystemsdc/iris-community:latest

FROM intersystemsdc/iris-community

And 

FROM intersystemsdc/iris-community:2022.1.0.114.0-zpm

equals to:

FROM intersystemsdc/iris-community:preview

And to launch IRIS do:

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community:2022.1.0.114.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-ml-community:2021.2.0.651.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community:2021.2.0.651.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community:2021.2.0.651.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-ml-community:2022.1.0.114.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community:2021.2.0.651.0-zpm

And for terminal do:

docker exec -it my-iris iris session IRIS

and to start the control panel:

http://localhost:9092/csp/sys/UtilHome.csp

To stop and destroy container do:

docker stop my-iris

Updated to 651, thanks, @Jeff Fried!

Also, we have the latest tag for ZPM images, so this will take the latest:

FROM intersystemsdc/iris-community:latest

Or just like this:

FROM intersystemsdc/iris-community

BTW, there is a very good one-liner to install ZPM, cortesy of @Guillaume Rongier:

set $namespace="%SYS", name="DefaultSSL" do:'##class(Security.SSLConfigs).Exists(name) ##class(Security.SSLConfigs).Create(name) set url="https://pm.community.intersystems.com/packages/zpm/latest/installer" Do ##class(%Net.URLParser).Parse(url,.comp) set ht = ##class(%Net.HttpRequest).%New(), ht.Server = comp("host"), ht.Port = 443, ht.Https=1, ht.SSLConfiguration=name, st=ht.Get(comp("path")) if 'st { w $System.Status.GetErrorText(st) q } set xml=##class(%File).TempFilename("xml"), tFile = ##class(%Stream.FileBinary).%New(), tFile.Filename = xml do tFile.CopyFromAndSave(ht.HttpResponse.Data) do ht.%Close(), $system.OBJ.Load(xml,"ck") do ##class(%File).Delete(xml)

Now this list could be expanded by Tableau, PowerBI and Adaptive Analytics (AtScale).

Included it into csvgen module.

to export SQL to CSV you can do the following:

USER>set query="select * from your.classname"
USER>w ##class(community.csvgen).SQLToCSV(";",1,"/folder/file.csv",query)

Hi @Guillaume Rongier !

I tried to use pip3 in the app and failed. I see it is being installed during the image build, but cannot run it later. What I'm doing wrong?

And images with ZPM package manager 0.3.2 are available accordingly:

intersystemsdc/iris-community:2021.2.0.651.0-zpm
intersystemsdc/iris-ml-community:2021.2.0.651.0-zpm
intersystemsdc/irishealth-community:2021.2.0.651.0-zpm 
intersystemsdc/irishealth-ml-community:2021.2.0.651.0-zpm  
intersystemsdc/iris-community:2021.1.0.215.3-zpm
intersystemsdc/irishealth-community:2021.1.0.215.3-zpm
intersystemsdc/irishealth-ml-community:2021.1.0.215.3-zpm
intersystemsdc/irishealth-community:2021.1.0.215.3-zpm

And to launch IRIS do:

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community:2021.2.0.651.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-ml-community:2021.2.0.651.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/iris-community:2021.2.0.651.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community:2021.2.0.651.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-ml-community:2021.2.0.651.0-zpm

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community:2021.2.0.651.0-zpm

And for terminal do:

docker exec -it my-iris iris session IRIS

and to start the control panel:

http://localhost:9092/csp/sys/UtilHome.csp

To stop and destroy container do:

docker stop my-iris

And the FROM clause in dockerfile can look like:

FROM intersystemsdc/iris-community:2021.2.0.651.0-zpm

Or to take the latest image:

FROM intersystemsdc/iris-community

Thank you, Robert! What you did and keep doing for the community is priceless! We are very lucky to have you! Thank you so much!