Minnesota's cannabis and hemp industries overhauled



A cannabis plant

Gov. Tim Walz has signed off on a sweeping cannabis package that will reshape the state’s emerging recreational market and give hemp operators a path forward ahead of a looming federal ban.

Some of the biggest changes will merge parts of Minnesota’s cannabis supply chain, encourage more medical cannabis production and help hemp producers move into the adult-use market before the ban takes effect Nov. 12.

State Rep. Jessica Hanson, DFL-Burnsville, was a sponsor of the “maintenance” bills. She says the bills respond to operational and regulatory challenges facing both cannabis and hemp businesses.

“We've left alone what's working and we've tweaked what needed some small tweaks to try to make it a little bit easier for folks,” she said.

Here’s what’s changing.

Hemp: QR code labeling, pathway to cannabis, ‘large format’ beverages

One of the biggest asks from the hemp industry was to bring back QR codes for product labeling, according to Hanson. The state phased out the use of QR codes as it began enforcing stricter packaging and labeling rules last year for low-potency hemp-derived edibles.

“Everyone wanted to be able to put a lot of the requirements under the QR codes because the packages get real full with a lot of information real quick. So those will be allowed explicitly to do that,” Hanson said.

Woman introduces bill
State Rep. Jessica Hanson, DFL-Burnsville, introduces the cannabis omnibus bill on the House floor during the last hours of the legislative session on May 17.
Courtesy of Minnesota House Public Information Services

The batch number, ingredients list and serving size still have to be visible on packaging, but information about a business's license and address can be consolidated within a scannable bar code.

Other changes for the hemp market clarify that state law allows up to 100 milligrams per serving of non-psychoactive cannabinoids (CBD, CBG, CBN, CBC) and up to 10 milligrams per serving of THC in edible “ratio hemp-infused cannabis products.” That lets companies create more products intended to treat chronic pain and other health issues.

Another allows beverage producers to make what Hanson called “large-format” beverages, which means instead of being limited to selling drinks containing at most two servings totaling 10 milligrams of THC, they can sell larger containers with up to 17 servings totaling up to 85 milligrams of THC, similar to a bottle of liquor.

THC drinks are displayed on a store shelf.
Hemp-derived THC drinks sit on a shelf inside a Top Ten Liquors store located in the Twin Cities.
Courtesy of Top Ten Liquors

And hemp producers looking to enter Minnesota’s adult-use cannabis market no longer have to shut down their existing business to do it. Lawmakers removed language barring hemp businesses from also holding cannabis licenses.

For Steven Brown, founder of Nothing But Canna, that’s a huge win. He’s transitioning into the adult-use market while running his hemp business, Nothing But Hemp.

“I would’ve had to divest from my company and I would have to move that to my other business partners, and then I would have to open up Nothing But Canna separately," Brown said. "For us to do what they would ask, it was just terrible."

Minnesota Office of Cannabis Management director Eric Taubel says after the state legalized adult-use in 2023, it made some sense to keep hemp and cannabis separate since hemp was seen as a runway to cannabis. But many successful, multi-state hemp producers like Brown were facing significant challenges with moving into recreational cannabis.

“Asking an operator to shelve that business in order to pursue a cannabis license, we didn't think it made a lot of sense. And because of the current distinction between hemp and cannabis at the federal level, there's a real business case to hold both licenses,” Taubel said.

man poses with employees
Nothing But Canna is still figuring out its next steps in the recreational market, but Steven Brown says the hope is to be able to retain all of its long-term employees through the change.
Courtesy of Steven Brown

Like many hemp producers, Brown is doubtful Congress will throw a lifeline to what’s now a multi-billion dollar industry in the U.S. The federal ban caps all hemp-derived cannabis products to 0.4 milligrams of THC per container, which would eliminate popular drinks and edibles. President Donald Trump signed it into law last fall as part of a deal to reopen the federal government.

Ongoing efforts in D.C. like Minnesota Sen. Amy Klobuchar's “Hemp Safety Enforcement Act” would protect existing hemp markets. Other proposed bills seek to delay the ban.

None of it is guaranteed.

“The days are counting down in session in Washington, D.C.,” Brown said. “I know it's still going on, but there's not too many vehicles left for hemp, and I need to understand how to forecast. Because it's either I wind down my business and start furloughing my employees or move into the adult-use space.”

He will continue to sell low-potency, hemp-derived edibles as long as it remains legal on the state and federal level. But if the ban does go into effect, he’s directing customers to Nothing But Canna.

Rebranded storefront
Nothing But Canna founder Steven Brown says he's been phasing out the rebrand for the past few years, including at one of his Nothing But Hemp retail stores in St. Paul.
Courtesy of Steven Brown

Cannabis: New macrobusiness license, supply chains merging, social equity ownership changes

On the cannabis side, there are significant shifts to the state’s medical cannabis program. Minnesota is now encouraging recreational cannabis businesses to serve medical patients as it moves to integrate the medical and recreational supply chains.

Hanson says this change comes after hearing from the state’s two medical cannabis companies, Vireo Health and Green Thumb Industries, that it was becoming costly to have separate supply chains. More than a year ago, Green Thumb Industries wrote to legislators in favor of unifying the supply chains.

“It's quite an administrative burden to try to track everything in two separate systems, so they were having to track in two Metrc systems, which is expensive, it's administratively a nightmare, and it's just burdensome,” she said. Metrc is a technology system required by the state to track cannabis from seed to sale.

Businesses can now grow, process and store recreational and medical cannabis in the same building.

A cannabis dispensary
Green Goods' Minneapolis location is seen on Sept. 16, 2025, the first day the longtime medical-cannabis provider began selling recreational cannabis.
Jo Larson | MPR News

“It's really moving more toward one market,” said Minneapolis-based cannabis lawyer Susan Burns. “We started out everything really siloed — medical, cannabis, hemp — but I think there's becoming more and more fluidity between those silos, and I think that's good.”

There was also concern that patient access to medical cannabis would suffer as the adult-use market grows. Merging the supply chain can increase product availability for medical patients and protect from market changes that would otherwise shrink access to medical cannabis.

Currently, only businesses with a medical combination license could sell both medical and recreational cannabis, and the only businesses with those licenses are the state’s two medical cannabis companies. The new law will get rid of that license and create a “macrobusiness” license, which will let recreational cannabis businesses produce and sell medical cannabis. A total of eight will be allowed.

The new framework also creates a pathway for cannabis businesses to scale up through Minnesota’s licensing system. After two years with a medical cultivation endorsement, a microbusiness can “graduate” to a mezzobusiness, and a mezzobusiness can move up to a macrobusiness.

A bag of marijuana
A bag and jar of Candy Crush marijuana at Meta Commercial Cannabis Real Estate in Minnetonka, Minn., on June 5, 2025. Meta Commercial Cannabis Real Estate does not have hands-on THC but does have products on hand from their clients.
Jackson Forderer for MPR News

“It gives social-equity applicants the priority on that, and that also has very common sense provisions. I think that the nice feature of the macrobusiness is that you can apply for a graduated license — a higher tier, if you will — and you don't have to lose your existing license,” Burns said.

The omnibus bill also helps social-equity license holders who are struggling to get capital investments. State law still requires social-equity license holders to maintain 65 percent ownership, which is a safeguard intended to keep large corporations from taking control. But an investor can now own up to 33 percent of up to four social equity cannabis businesses — a major increase from the previous 10 percent ownership cap.

Hanson says it’s not a silver bullet, but it should help social-equity business owners get started in the market.

“The change we made was in response to social-equity business owners telling us that they were having a hard time finding investors who are interested in investing in their business,” Hanson said.

The hope with these cannabis policy changes is for Minnesota to have a strong, equitable market and protect its hemp industry despite an uncertain future.



Source link

Leave a Reply

Subscribe to Our Newsletter

Get our latest articles delivered straight to your inbox. No spam, we promise.

Recent Reviews


Data Modelling in QlikView – Table of content

Introduction to QlikView:

QlikView is one of the top business intelligence tools which provide end-to-end platform services. The main operations of the QlikView tool included are data integration, user-driven business intelligence, and data analysis. The QlikView business tool helps users to convert the raw data into a useful one. This tool sometimes acts as a “Human brain” and mainly works on business associations. This software tool was first found in 1993 in Lund, Sweden, and is now based in King Of Prussia, Pennsylvania, United States.

As is said earlier, QlikView is one of the most demanding business intelligence tools. This tool is used to maintain the relationships between the data and visual colors. Users can also perform direct as well as indirect searches by using various searches in the given list boxes. One more important thing about QlikView is that this helps in the calculation of aggregated data and data compressions. Neither users nor software developers of the QlikView application manage the relationship between the various data sources, but this is managed automatically (you can say by default it happens).

Take your career to next level in Qlikview with hkr. Enroll now to get QlikView Online Training demo!

Major features of QlikView:

QlikView’s business intelligence tool comes up with advanced features. Following are the list of QlikView features:

1. Automatically maintains the data association:

QlikView tool automatically identifies the relationship between the data present in a data set. With the help of this feature, users need not recognize the relationship between the various data entities.

2. Data will be held in the memory available for multiple users and offers a super-fast user experience:

Here the data structure and calculations of a data report will be held in the RAM memory of the server.

3. Aggregations can also be calculated on the fly:

As data will be held in memory, the user performs a calculation task on the fly. Here there is no need to store pre-calculated aggregate data values.

4. Data will be compressed to 10% of the original size:

QlikView platform developed on the base of data dictionaries. Only essential data sets will be used for analytical purposes and this compresses the original data to a small size.

5. Visual relationship by using colors:

With the help of this feature, the relationship between the data will not be shown by lines and arrows. All you need to do is select a piece of data by click on specific colors to specify the related data and another color to specify unrelated data.

Qlikview Training Certification

  • Master Your Craft
  • Lifetime LMS & Faculty Access
  • 24/7 online expert support
  • Real-world & Project Based Learning

What is data modeling in QlikView?

A data modelling in QlikView is nothing but a pictorial representation of data tables that present in the various database servers, which also include associated relationships to show the data flow process of the entire system or model. This data modeling also helps to define the key fields and data dependency factors that help to perform the normalization and simplification process. The data modelling also a combination of dimensional tables that are linked to represent the fact table and also ends up with a star schema that helps to trade off on the available resources.

QlikView also performs in a good way when the data model is well structured and designed. A good data model also ensures that the quick data process provides accurate results, and evaluates the expressions. Data modeling in QlikView also consists of dimensions and key values within the data fields.

Best techniques used to perform Data modelling in QlikView:

The following are the important key techniques used to perform the data modelling process:

1. Using QVD files to increment data loads:

While performing the data modelling technique, the incremental load is a very common task in the relation to the database servers. It is defined as data loading (which helps to define new or modified records from the various database servers). All the data records will be stored in the QVD file formats.

The following are the important steps that will be considered to perform QVD files increments:

1. First you need to load the data from the database tables (this is considered to be a slow process, but helps to load the limited number of data records).

2. Next you need to load the old data from the QVD files (helps to load the data records in a faster way).

3. Now you need to create the QVD file formats.

4. You need to create the procedure for every table you loaded.

Get ahead in your career with our QlikView Tutorial !

2. Combining the data tables with Join and keep tables:

We already know that join takes any two different tables and combines them into one table. This process is also known as the “natural join table”. In QlikView, this type of join process can be done by using scripts and also logical data tables’ formats.

Let me explain these two methods in brief:

1. Join:

The easiest way to perform the joins process with the help of the join prefix in the script. The join is an internal table with another name table or previously created tables. The join usually used here is an outer join and used to combine values from the two tables.

For example:

LOAD a, b, c from table1.csv;

JOIN LOAD a, d from table2.csv;

2. Keep:

This is one of the main features of QlikView and helps to associate between any two tables instead of joining them. These keep features also help to reduce the memory space, increase the speed and enormous flexibility. The keep functionality helps to reduce the number of cases where the user needs to make use of explicit joins. In general, the Keep prefixes between two statements are LOAD and SELECT.

Acquire Data Modelling certification by enrolling in the HKR Data Modelling Tutorial program in Hyderabad!

HKR Trainings Logo

Subscribe to our YouTube channel to get new updates..!

3. Using mapping as an alternative to the joining process:

The Join prefix is a powerful method used to combine several data tables in QlikView. You can also find one disadvantage of using this Join prefix is that while combining larger and big data tables will reduce the performance. To overcome this hurdle, now we have come up with Mapping, this mapping method consists of two columns they are; a comparison field (as an input) and a mapping value field (as an output).

4. working with cross tables:

A cross table is a common type of data table that performs a matrix of values between any two orthogonal header data lists. The crosstable is often preceded by a number of various qualifying columns; you can read them in a straightforward way.

5. Using Generic databases:

A generic database is a kind of table in which all the field names will be stored as field values in one table column, where the field values will be stored in a second. Generic databases are usually used to define the attributes of different objects.

6. Matching intervals to discrete data:

The interval values can be defined using two prefix statements they are; LOAD and SELECT. These statements are used to link the discrete values with the two or more numeric intervals. This is one of the powerful data modelling techniques used in QlikView nowadays.

Top 30 frequently asked QlikView interview questions & answers for freshers & experienced professionals 

7. Creating a data interval from a single date:

Sometimes, when you are working with data modelling, usually the time intervals are not stored with a beginning and end of the time limit. Suppose if you don’t create any data interval, then the date value will be implied by only one field or the change timestamp.

8. Hierarchies:

In data modelling, n-level of hierarchies are used to represent other data fields (geographical and organizational dimensions in the data). These types of hierarchies are usually stored in any adjacent table nodes, for example, each record stored as a node, and the field represents the reference to the parent node.

9. Semantic rules:

Usually, semantic tables are not displayed in the table field viewer.

Below are a few semantic rules:

1. The semantic table should contain three or four columns.

2. The prefix statements like LOAD and SELECT load the semantic table and this table should be preceded by a semantic qualifier.

3. A semantic table either contains a relation between field values of the different fields or field values of the same field. One more important point to be remembered here, a mixture between these two will not be accepted.

10. Data cleansing:

When you load the data from the various tables, the field values will not be named consistently. Data cleansing is required, when there is a lack of consistency, and hinders association.

Qlikview Training Certification

Weekday / Weekend Batches

Conclusion: 

The data modelling in the QlikView blog helps users to create a structured and well-designed data model in QlikView. We have also discussed the top 10 best practices used in data modelling. With the help of data modelling users can understand the data landscape and also enables the organization to analyze and data extraction. Data modelling is considered to be a very important method in many business intelligence tools to perform data analysis and visualization tasks.

Other Related Articles:



Source link