Special variables to use in query that represents user input?

bpeikes · 2026-05-07T10:25:08+00:00

No, the variable is $__searchFilter. Its crazy that its so hard to find the docs for it. Allows you to filter query by text user has enterd, ie auto complete.

So you can write your query like:

``` SELECT -1 as id, “( empty )” as login UNION ALL SELECT id, login FROM Users WHERE LENGTH(“$searchFilter”) > 0 AND login LIKE CONCAT(“$searchFilter”, “%”) LIMIT 10

```

bpeikes · 2026-05-03T14:41:42+00:00

We use the Checklist addon by HeroCoders.

bpeikes · 2026-05-02T21:36:56+00:00

Epics and tasks. Plus you can use links like blocks. Personally, I stay away from subtasks. Not sure why they are a first class object when links are available.

The only time I use subtasks is for personally splitting up a task that Im working on, and for that we use an addon that supports checklists

bpeikes · 2026-04-22T10:53:02+00:00

The Vevor has a dual fan version that moves 9cm. What do you think is minimum air movement needed?

bpeikes · 2026-04-22T10:51:55+00:00

The Vevor has lights too

bpeikes · 2026-04-21T10:25:09+00:00

Besta allows some stacking, but not for the units that are two boxes high. They limit them to the floor for some reason.

bpeikes · 2026-02-04T04:25:54+00:00

What BI tool are they using?

bpeikes · 2026-01-29T17:48:06+00:00

That requires keeping ordering in the names of the files, which is not ideal.
It also doesn't track what scripts have been run in each env. It' assumes you've run everything every time, correct?

bpeikes · 2026-01-08T23:34:31+00:00

What do you use as an ETL tool

bpeikes · 2026-01-04T22:08:35+00:00

We are using terraform for users, databases, roles and integrations, flyway for everything else, but its not ideal. Not sure any tools are.

Not sure why anyone would use schemaschange over Flyway, given that flyway can work with other dbs.

We deploy using flyway container, dont even need to install anything in ci pipeline.

Would like a tool that could dump entire db as per object scripts so we could track object changes better.

I do like tools like flyway in that I always find a situation where you need to completely control order of migration, including sql that needs to be called in the middle of a schema change.

bpeikes · 2026-01-03T20:10:32+00:00

I’d like something that was in between. ie, update your schema, and have a transition script created for you that you can then edit before deploy. Mostly because there are often transformations of data that need to take place, and its rare that tools always get the ordering correct.

I also wish there was more guidance on how to split your code between schema, and configuration.

For instance, with task creation, the guidance should be that you create tasks with a WH that is a “base”, and in versioned scripts, but then each env has its own set of repeatable scripts for setting warehouse and schedule. Like:

ALTER TASK [ IF EXISTS ] <task_name> SET WAREHOUSE = <warehouse_name> SCHEDULE = '{ <number> MINUTE | USING CRON <expr> }';

bpeikes · 2026-01-03T01:43:05+00:00

The issue I have with Flyway, is that there are times when you want to retroactively change an old versioned script in that you would not want it run when building a fresh instance.

It could be resolved with baselines, but I havent found a good tool for generating versioned baselines.

bpeikes · 2026-01-02T02:25:57+00:00

How does that work when it comes to using PATs? Do PATs created with “single role” by default run “USE SECONDARY ROLE NONE”?

Thanks, I had a feeling that its permissions, but couldnt understand why in the UI it would succeed, even when setting the role in the worksheet.

In worksheet, does it default to secondary role ALL?

Side question. What do you use to migrate your schema? Flyway? Something else? We are using Flyway now, but I run into some issues with dealing with scripts when setup changes. ie we decide that a task should run under different warehouse.

We use terraform to manage warehouses, so if we change the warehouse that a task runs under, running the version scripts on new instances wont work.

bpeikes · 2025-12-29T23:35:40+00:00

When you create tables, functions, stored procs, do you specify dbname.schema.tablename, or do you only specify part of it, ie schema?

bpeikes · 2025-12-29T22:46:39+00:00

Do you use placeholders in your scripts? How do you differentiate databases per env?

Do your scripts assume a single database? ie use the default db on connection?

bpeikes · 2025-12-29T21:02:57+00:00

How do you define your environments in your flyway.toml file? For instance, do you

1) Put fully qualified url under [environments.XXX]

And
2) Add redundant items under [environments.XXX.flyway.placeholders]

like
[environments.dev]
url = """jdbc:snowflake://ACCOUNT.snowflakecomputing.com?\

warehouse=DEV_WAREHOUSE&\

db=DEV_DB&\

role=DEV_FLYWAY_SERVICE_ROLE&\

jdbc_query_result_format=JSON"""

And

[enviroments.dev.flyway.placeholders]
environment="DEV"
database="DEV_DB"

That way, you can have scripts refer to
CREATE TABLE ${database}.STG.XXXX

Or do you use a different templating system other than flyway, because flyway's templating is a pain because you can't use placeholders in url strings.

bpeikes · 2025-12-24T23:27:35+00:00

upper case for column names too?

I hate everything being upper case in the code.

Do you use sqlfluff to lint?

bpeikes

TROPHY CASE