metabase / metabase/metabase

Using custom environment variables, on metabase SQL Query

Open
#6,383 0 comments 2 reactions 0 assignees View on GitHub
Operation/Environment variables Querying/Native Querying/Parameters & Variables Type:New Feature
Dominant language
Clojure
Stars
49.3k
Forks
6.8k
Avg merge
1d 13h
Merged PRs (30d)
653

Description

### Feature requests and proposals

I am currently having a problem with a SQL Question that has an sql statement for decrypting a column. As of now (devs would only be the users for this) we are adding the keys every time we run the SQL Query Question.

Request: Using custom environment variable inside SQL Query Questions would be an additional security removing the key from plain sight, but still allowing users to query the encrypted column that has the data

Would also like to know if there is another way around this problem, currently looking for other solutions.

Contributor guide

Open the contributing guide

Research direction

No files, tests, or entry points are identified. Start by reviewing how SQL Query Questions receive parameters and how Metabase handles custom environment variables, then confirm the security model with maintainers. Done means a defined, supported way to use the secret without exposing it in the query or interface, with tests covering the approved behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
clojure, sql
Domain
database, security
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.