Hello InfluxDB Community, I hope this message finds you well. I’m new to InfluxDB 2 and the FLUX language, and I have encountered a challenge that I would greatly appreciate your expertise and guidance with. Context: Tracking Sales and Shipping Data In my project, I have two buckets: Database 1…

@ajetsharwin In the example below, I use the sample data you provided to generate the desired results. I use array.from() to build ad hoc streams of tables using the Flux data model, but you can replace these variables using from() |> range() |> filter() calls to query actual data from your buckets.…

@Anaisdg , @scott tagging for attention, any guidance would be much appreciated :pray:

@scott Thank you very much for all of the above and the comments in the codeblock. I have some follow-ups to better learn about the FLUX language and the approach you’ve chosen: I did not know we can write (key) => true. Can you please shed some light on the syntax here? What are spectrum of par…

[image] ajetsharwin: I did not know we can write (key) => true. Can you please shed some light on the syntax here? What are spectrum of parameters we can pass into the fn: function? Is this (key) => true shown anywhere on the docs? The findRecord() function’s fn parameter is used to identify …

Hey @scott , having recently come to terms with InfluxQL queries being faster than Flux lack of Flux support in Influx 3 One of the primary motivations to move to Influx2 and use Flux is to allow data manipulation from different databases; and your solution above makes a lot of sense and works wel…

@ajetsharwin Unfortunately, this is not possible with InfluxQL (but may be with SQL in v3, I need to test).

Combining Data from Multiple Databases in InfluxDB 2 using FLUX

InfluxDB 2

ajetsharwin June 21, 2023, 8:24am 6

Thank you Scott! noted on all that you’ve written above.

Merging two different Measurement with similar but NonIdentical timeStamp?

Topic		Replies	Views
Create new column to store calculation of two fields from different buckets InfluxDB 2 influxdb , query , flux	6	8436	June 23, 2021
Influx 1.8 - Query across Databases InfluxQL influxdb	2	733	January 5, 2022
Join big measurements together - Error Bad Gateway Fluxlang chronograf , sensors , flux , performance	13	1751	September 18, 2020
Join Data quickly -- InfluxQL 1.8 vs Flux 2.0 performance InfluxDB 2 influxdb , chronograf , flux , join , union	2	1503	January 28, 2022
Create 1 table from 2 other tables Dashboards	3	583	April 2, 2020

Combining Data from Multiple Databases in InfluxDB 2 using FLUX

Related topics