What you can do with Python / SQL cells
This section describes some functional details of Python / SQL cells, which are expected to be used particularly frequently in Canvas.
Processing and importing external data (SQL cells only)
Select the code icon from the bottom icons and place the SQL cell. Open the Editor screen of the SQL cell. Then, while checking the schema of the connection destination, write SQL statements and press Run in the upper right corner to process data and import data from an external source.
AI Assist
You can use AI to generate, modify, and explain code from the chat tab on the side menu of the Editor screen, or by specifying a range of code, right-clicking, and then clicking Start inline chat.
Updating Source
If you create a structure A.Source cell -> B.Python cell or SQL cell -> C.Source cell, C cell will not be automatically updated even if A cell is updated.
<Manual Update>
Press the calendar icon at the top of the C cell to open the side menu; on the Manual tab, press Run Manually to perform a manual update. The cell highlighted with a yellow frame will be updated.
<Automatic Updates in Scheduling>.
Switch to the Schedules tab in the side menu and press + Add Schedule at the bottom. The contents of the schedule will be set to Scheduled Auto Update. The schedule will be applied if Enabled is checked. If you want to leave the schedule settings in place and stop the scheduling execution, uncheck Enabled.
